Replace a warning message...on protected cell

  • Thread starter Thread starter mika
  • Start date Start date
M

mika

I have a protected cell, when the user try to modify it,
we received the following message:
"The cell or chart you are trying to change is protected
and therfore read-only."

My question is: How can I change this message to replace
it by my custom message...like: "You hit a protected cell,
please contact the administrator to change it at xxxxx"

Is it possible to do this...Any code or sugestions will be
welcome...

Thanks
 
Try using "Data, Validation' from the standard Excel toolbar

In the settings tab, choose something that a user is never going to
enter. I often use

'Allow': Decimal
'Data' :equal to
'Value': 0.00095623745 (say)

On the Error Alert, enter your message, e.g.
"You hit a protected cell" in the 'Error message:' text box
and select the 'Stop' option in the 'Style' drop down box.

An alternative is to type the same message into the box on the 'Input
Message' tab when you've selected the 'Show input message when cell is
selected' tick box. This shows the same message immediately the cell
is selected.


The advantage of this method is that you don't need to protect the
worksheet.


Rgds

On Wed, 11 Aug 2004 11:23:00 -0700, "mika"

RB>I have a protected cell, when the user try to modify it,
RB>we received the following message:
RB>"The cell or chart you are trying to change is protected
RB>and therfore read-only."
RB>
RB>My question is: How can I change this message to replace
RB>it by my custom message...like: "You hit a protected cell,
RB>please contact the administrator to change it at xxxxx"
RB>
RB>Is it possible to do this...Any code or sugestions will be
RB>welcome...
RB>
RB>Thanks

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
Back
Top