Protecting entire workbooks

An entire workbook can be password protected to prevent access when saving.  Simply click “save as and you are presented with the following options.

Protecting Excel workbooks

Use the “Save As” function as normal and navigate to the “Tools” option next to the “Save” button.  Click on the down arrow to reveal further options and select “General Options”.

Protecting Excel workbook 2