Open an Excel workbook as Read-Only

How to open a single workbook as Read-Only using Excel and VBA methods

METHOD 1. Open an Excel workbook as Read-Only

EXCEL

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. Select File tab

2. Click Open.
3. Click Browse.
Select Open 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.
Select workbook and click Open Read-Only

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.
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.

Explanation about how to open a workbook as Read-Only

EXPLANATION

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.

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
How to open a workbook that was recently used and closed using Excel and Shortcut methods
How to open a single workbook using Excel, VBA and Shortcut methods
How to open a single workbook in Protected View using Excel and VBA methods
How to close a single workbook using Excel, VBA and Shortcut methods
How to save a workbook using Excel, VBA and Shortcut methods