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 you want to protect.

  2. Click the File menu, and then click Passwords.

    Password option in the File menu
  3. In the File Passwords dialog box, 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.

  1. Open the workbook that you want to protect.

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

    Review tab, Protection group

  3. In the File Passwords dialog box, 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

Set or clear read-only status

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×