Pop up window when closing excel

Can someone tell me if it is possible to have a window pop up reminding users if the have protected a worksheet when they have unprotected it. It is very annoying that people unprotect a sheet and forget to prtect it again. I am using Office 2007.

you can write a statement in your Workbook_Open event to protect all worksheets, so the program will always open with all sheets protected OR you can write similar statements in Workbook_BeforeClose event.

modytrane

Sorry, but how do I do that?

Open the attached file.
All three sheets are protected with password: xyz.
If you unprotect the sheets and save the file and then re-open it, you'll find that the sheets will be protected.
To see the macro, right click on one of the tabs below [sheet1 or sheet2 etc.]. Select view code.
When VBA explorer opens, Doubleclick on ThisWorkbook. You'll see the code.
In the code, you can change the name of the worksheet or change the password.
hope this helps.
modytrane