Alert messages

J

Johno

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/com...96f12b4&dg=microsoft.public.excel.programming
 
J

JLGWhiz

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

eliano

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

Hi JLG.
Many many thanks from a relatively inexperienced user.
Eliano
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top