Open an Excel workbook in Protected View
How to open a single workbook in Protected View using Excel and VBA methods
| 1. Select the File tab. |  |
| 2. Click Open. 3. Click Browse. |
 |
| 4. In the Open dialog box locate the Excel workbook file that you want to open and select the workbook. 5. Click on the arrow next to Open. This will display a list of options. 6. Select Open in Protected View. Note: in this example we are opening a workbook, in Protected View format, titled Examples. |
 |
METHOD 1. Open an Excel workbook in Protected View using VBA by directly referencing the file path and workbook name
VBA
Application.ProtectedViewWindows.Open "C:\Excel\Examples.xlsx"
End Sub
Workbooks: The Workbooks object represents all of the open Excel workbooks.
Workbook location: Have a workbook that you are referencing to in the VBA code on your device in the C:\Excel\ path.
Workbook Name: Have a workbook named Examples.xlsx, in the location specified in the VBA code.
ADJUSTABLE PARAMETERS
Workbook location: Select the file path of the workbook that you want to open by changing the C:\Excel\ path.
Workbook Selection: Select the workbook that you want to open by changing the Examples.xlsx workbook name in the VBA code to any workbook that is located in the path provided in the VBA code.
This tutorial explains and provides step by step instructions on how to open a single workbook in Protected View using Excel and VBA methods.
Excel Method: This tutorial provides one Excel method that can be applied to open a workbook in Protected View with a browser and selecting the Open in Protected View option. This is achieved in six steps.
VBA Method: This tutorial provides one VBA method to open a workbook as Read-Only in Protected View by directly referencing to a specific workbook.
| Related Topic | Description | Related Topic and Description |
|---|---|---|
| Open an Excel workbook that was recently used | How to open a workbook that was recently used and closed using Excel and Shortcut methods | |
| Open an Excel workbook as Read-Only | How to open a single workbook as Read-Only using Excel and VBA methods | |
| Open an Excel workbook | How to open a single workbook using Excel, VBA and Shortcut methods | |
| Close an Excel workbook | How to close a single workbook using Excel, VBA and Shortcut methods | |
| Save an Excel workbook | How to save a workbook using Excel, VBA and Shortcut methods |