Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trapping warning message
I don't believe you can suppress this. However you can use the
enableselection property of the worksheet to prevent the user from selecting protected cells - then there will be no message. -- Regards, Tom Ogilvy b0rk wrote in message ... When users inadvertantly try to enter data in a cell on a protected sheet, a very long winded message appears: "The cell cell you are trying to change is protected ..etc" This message does not seem to obey the "DisplayAlerts=False" command and I cannot find where it originates from. I would like to trap this to remove it or replace it with my own message. Can anyone help? b0rk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get rid of the warning message | Setting up and Configuration of Excel | |||
warning message | Excel Discussion (Misc queries) | |||
Warning Message | Excel Discussion (Misc queries) | |||
warning message | Excel Discussion (Misc queries) | |||
How to I get a warning message box | Excel Worksheet Functions |