Method 1 – Directly Open Workbook as Read-Only Go to the Developer tab and click on Visual Basic. If you don’t see the Developer tab, enable it or press Alt+F11. In the Visual Basic Editor, click Insert and s
If you don’t have the password, you can open the file as Read Only. Click OK. When we open the file as read-only, we will not be able to edit or update the file. How to Disable Read Only Mode in Excel Case 1 – When Read Only File Is Not Protected with Password Steps: ...
Case 1. Open MS Excel files in read-only mode The most common Microsoft Excel read-only problem is found in newer versions of the program. According to many users, this error occurs if you download an XLS or XLSX file from the Internet. But the reason can be many things: broken setting...
2. In the opening Microsoft Visual Basic for Applications window, copy and paste the below VBA code into the Code window. VBA code: Make cell as read only in Excel Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Column = 1 Then If Target.Row = 3 Or Target.Row ...
Make Workbook Ready Only Using Save As in Excel Navigate to Save As: With your file open in Excel, you will need to navigate to the “Save As” function. To do this, click “File” again in the top left corner, but select “Save As” from the drop-down menu. This will lead you...
Step 1. First, select the "Read Only" button to open the Excel file. Step 2. Select "File" in the menu bar and select "Save As" from the drop-down list. Step 3. Change the saved file type and click the "Save" button.
Sometimes we may make an Excel template for others applying easily, but do not want them to change the template files. A read-only Excel template can help you prevent others modifying template files, but doesn’t affect applying. In this article, I will show you the method to make a read...
This tutorial demonstrates how to change a read-only file in Excel and Google Sheets. Change a Read-Only File Without a Password To edit aread-only filethat has no password protection, once you open a file, clickEdit Anywayin the yellow read-only warning. ...
Way 2: Excel file is in read-only recommended When you open a read-only recommended Excel file, you will be prompted to open this Excel file in read only mode, unless you need to make changes to this Excel file. So, if you don't want to make change to this Excel file, click on...
Marked As Final is an option in Excel that lets you save your Excel document as a final draft so that no one can make further changes. If you open a Marked As Final Excel document, it will be opened in read-only mode. Part 2: How To Remove Read-only inWPS Spreadsheet?