protect all sheets when closing excel

[JESSIER4025]

I need a little help with code to have excel to protect all sheets upon closing excel.
I have two buttons already that will unprotect and protect while working with file but as a safety precaution i would like excel to protect all when someone closes the file.


Any help would greatly be appreciated!

[royUK]

This should do it

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
In the Project Explorer, find your workbook, and open the list of Microsoft Excel Objects
Right-click on the ThisWorkbook object, and choose View Code
Where the cursor is flashing, choose Edit | Paste