Replace a warning message...on protected cell
 

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

Replace a warning message...on protected cell
 

Hi
AFAIK you can't change this

--
Regards
Frank Kabel
Frankfurt, Germany


mika wrote:
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

Replace a warning message...on protected cell
 

It's work fine...Thank you for your help!
-----Original Message-----
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"
wrote:

RBI have a protected cell, when the user try to modify
it,
RBwe received the following message:
RB"The cell or chart you are trying to change is
protected
RBand therfore read-only."
RB
RBMy question is: How can I change this message to
replace
RBit by my custom message...like: "You hit a protected
cell,
RBplease contact the administrator to change it at xxxxx"
RB
RBIs it possible to do this...Any code or sugestions
will be
RBwelcome...
RB
RBThanks

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
.