View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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