You can use the WorkbooksBeforeClose event to ensure the sheet is protected
and saved, without worrying about the user.


"Johno" wrote in message
...
Is there a better way to notify a user that a worksheet is unprotected
other
than reviewing the toolbar.

For relatively inexperienced users, it is oftentimes necessary for them to
unprotect a worksheet, clear some rows which contain various locked
columns
and then re-protect the sheet. An alert message (flashing in the
worksheet)
would prevent them from forgetting to re-protect.

Even better would be to not have to unprotect the sheet. Clearing a row
containing both locked and unlocked cells should allow the unlocked cells
to
clear without having to unprotect the sheet.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming