Open an Excel workbook as Read-Only
How to open a single workbook as Read-Only using Excel and VBA methods
File tab > Open > Browse > Select the location of the workbook > Select the workbook > Click arrow next to Open button > Select Open Read-Only
1. Select the File tab. |
2. Click Open. 3. Click Browse. |
4. In the Open dialog box locate and select the Excel workbook file that you want to open. 5. Click on the arrow next to Open. This will display a list of options. 6. Select Open Read-Only. Note: in this example we are opening a workbook, in Read-Only format, titled Examples.xlsx. |
METHOD 1. Open an Excel workbook as Read-Only using VBA by directly referencing the file path and workbook name
VBA
Sub Open_a_Workbook_as_Read_Only()
'Open a Workbook as Read-Only
Workbooks.Open "C:\Excel\Examples.xlsx", ReadOnly:=True
End Sub
PREREQUISITES
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.
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.
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.
EXPLANATION
This tutorial explains and provides step by step instructions on how to open a single workbook as Read-Only using the Excel and VBA methods.
This tutorial explains and provides step by step instructions on how to open a single workbook as Read-Only using the Excel and VBA methods.
Excel Method: This tutorial provides one Excel method that can be applied to open a workbook as Read-Only with a browser and selecting the Open Read-Only option. This is achieved in six steps.
VBA Method: This tutorial provides one VBA method to open a workbook as Read-Only by directly referencing to a specific workbook.
RELATED TOPICS
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 | How to open a single workbook using Excel, VBA and Shortcut methods | |
Open an Excel workbook in Protected View | How to open a single workbook in Protected View using Excel and VBA 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 |