All the definitions on AZdictionary were written by people just like you. Now's your chance to add your own!
1 In Excel, select â File â and click Save As. 2  Choose â Tools General Options â at the bottom of the window. 3  Select the check-box for â Read-only recommended â, then select â OK 4  â. Select â Save 5  â. If prompted, choose â Yes â to update the file with the read-only setting.f you have a file that is sensitive to changes, you can force Excel 2013 or 2010 to prompt the user to open as Read Only whenever they attempt to open the file. Hereâs how to enable this setting. 1  In Excel, select â File â and click Save As. 2  Choose â Tools General Options â at the bottom of the window.
When I change the file mode using Toggle Read Only the workbook_open() event triggers again and resets the file to Read-Only. In Excel 2003 the workbook_open() event was not triggered on a ChangeFileAccess xlReadWrite. have added the Toggle Read Only button to my quick access bar. 1  Create a new workbook. 2  Save the workbook. 3  Click Toggle Read Only and [Read-Only] is displayed in the title bar. 4  Enter text into a cell. 5  Click Toggle Read Only then the dialogue box appears as shown above.