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

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


"Johno" <(E-Mail Removed)> wrote in message
news:ED05F583-F2EA-44B2-9D6A-(E-Mail Removed)...
> 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

On 9 Lug, 22:01, "JLGWhiz" <JLGW...@cfl.rr.com> 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