Prompt to open a workbook as read-only

If you want to remind everyone that a workbook should only be changed if necessary, you can recommend that the workbook be opened as read-only.

Note: Prompting to open as read-only will not prevent changes from being made to your workbook. For stronger protection, set read-only status by locking the workbook with the Finder, or require a password to save changes.

  1. Open the workbook that you want to protect.

  2. On the Review tab, under Protection, click Passwords.

    Review tab, Protection group

  3. Select the Read-only recommended check box, and click OK.

  4. Close the workbook.

    The next time the workbook is opened, a message will ask if you want to open as read-only.

See also

Restricting changes by using read-only status

Set or clear read-only status

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!