Blog Archives

How To Protect An Excel 2016 Workbook

We can easily protect a sensitive or a confidential Workbook, either by assigning a password, either restricting access to it avoiding unwanted editing. We can also protect a document from being opened. As mentioned in a previous post of mine Protect A Word 2016 Document, the same procedure stands here, with the difference that some commands might be not available or some more will be available. All we have to do is to follow the steps below.

Fist we must select the File tab in order to move to backstage view as shown in the image below. Once in backstage view we make sure that the Info category from the left is selected. Then from the middle of the drop down menu we notice three different categories which are the following:

  • Protect Document: Control What Types Of Change People Can Make To This Workbook.
  • Inspect Document: Before Publishing This File Be Aware Of Its Contents: Author’s Name and Absolute Path
  • Manage Document: Check Out Document Or Recover Unsaved Changes.
  • Browser View Options: We Can Pick What Viewers Can See When This Workbook Is Viewed On The Web

Backstage View - Info

Read the rest of this entry

%d bloggers like this: