There may be times when you want to encourage users to open a workbook as read-only
Saving your Workbook
When you save your workbook, select the Tools drop-down and choose General Options
In this dialog box select "Read-only recommended" and press OK
The next time you open this workbook you will see the following prompt
Using this technique for read-only gives you the option when you open the file, and also allows you to quickly toggle between editing and read-only.
Toggle Read Only
There is a built-in command which allows you to quickly toggle a read-only file to editing and back again.
The "Toggle Read Only" command has not been added to any of the built-in ribbon tabs but can be added from the Excel Options, Customise dialog box.
At the top choose "All commands" and scroll down to Toggle Read Only
Read Only Attribute
You can change the file attribute to read-only using Windows Explorer but this is not as flexible.
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext