I don't think you can change that message, but maybe you could stop the users
from selecting those protected cells:
Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.Protect Password:="hi"
.EnableSelection = xlUnlockedCells
End With
End Sub
Excel won't remember these settings after you close it and reopen the workbook
(that's why it's in auto_open).
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Sadia wrote:
Hi,
I am trying to find a way to suppress an excel message from appearing.
For example, if a user tries to change value in a protected cell he
gets the following message:
"The cell or chart you are trying to change is protected and therefore
read only....."
I want to know if there is a way to avoid this message from appearing.
Can I stop this message from appearing and show my own customized
message?
Thanks
Sadia.
--
Dave Peterson