Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alert messages
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alert messages
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alert messages
On 9 Lug, 22:01, "JLGWhiz" wrote:
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A macro to deactivate Input Message textbox without deactivatingError Alert messages | Excel Programming | |||
Alert messages, running totals, connecting spreadsheets or cells | Excel Discussion (Misc queries) | |||
How to Create Sound Alert and Email Alert when Macro is Finish | Excel Programming | |||
Removing some alert messages | Excel Discussion (Misc queries) | |||
Excel 2003 Alert Messages | Excel Programming |