Use the workbook_beforeClose event

if worksheets("Sheet1").ProtectContents = False then
msgbox "Protect sheet"
cancel = true
End if

--
Regards,
Tom Ogilvy

Maria wrote in message
...
Hello;

I would appreciate help with this one:

I have a worksheet which is protected with a password. Some (select) users
have access to the password and can modify it and are instructed that
after
modifying it, they should again protect it using the same password so that
it cannot be changed by other users.

Sometimes users forget to re-protect the sheet. What code would be
required
to alert the user that the worksheet is unprotected & that he/she should
password protect it. This code should get activated when the user exits
from
the worksheet & goes to another without protecting it.


TIA
Maria