Then you just need to click Enable Content button (or Options button in Excel 2007), and it will exit the project view. When we open an Excel file that is downloaded from the Internet or other locations, there is a Security Warning bar above the formula bar.Ģ. Step by Step on how to disable protected view in Excelġ. Now I tell you some quick tricks to disable protected view in Excel. Sometimes, you may think this protected view is annoying, and you want to disable it. Workbook - Represents a Microsoft Excel workbook.When we download or copy an Excel file from the Internet or other unsafe locations to our computer, for the security of our computer, the Excel workbooks are opened as protected view. Workbook returns an object that represents the workbook that is open in the specified Protected View window. WindowState returns or sets the state of the specified Protected View window. Width returns or sets a value that specifies the width, in points, of the specified Protected View window. Visible returns or sets a value that determines whether the specified Protected View window is visible. Top returns or sets a value that represents the distance, in points, from the top edge of the specified Protected View window to the top edge of the usable area.
Left returns or sets a value that represents the distance, in points, from the left edge of the client area to the left edge of the Protected View window. Height returns or sets a value that represents the height, in points, of the Protected View window. SourcePath (Default member) - Returns the path of the source file that is open in the specified Protected View window.ĮnableResize true if the Protected View window can be resized. SourceName (Default member) - Returns the name of the source file that is open in the specified Protected View window. PropertiesĬaption (Default member) - Returns or sets a value that represents the name that appears in the title bar of the Protected View window. Dim pvw As ProtectedViewWindowįor Each pvw In Application.ProtectedViewWindowsĪctivate - Brings the Protected View window to the front of the z-order.Ĭlose - Closes the specified Protected View window.Įdit - Opens the workbook that is open for editing in the specified Protected View window. Here is an example of processing the ProtectedViewWindow items in a collection. The following procedures can be used to set variables of type ProtectedViewWindow: Application.ActiveProtectedViewWindow, ProtectedViewWindows.Item and ProtectedViewWindows.Open. Set pvw = Application.ActiveProtectedViewWindow To use a ProtectedViewWindow class variable it first needs to be instantiated, for example Dim pvw as ProtectedViewWindow The class ProtectedViewWindow represents a Protected View window.Ĭlass Application gives access to class ProtectedViewWindow.
0 kommentar(er)
