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.
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”.