Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppressing an excel message
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppressing an excel message
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppressing an excel message
Thankyou so much Dave, this little piece of code did the trick!
Sadia. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I keep excel from suppressing leading zeros as text | Excel Discussion (Misc queries) | |||
Suppressing or trapping system msgs in excel 2k | Excel Programming | |||
suppressing error message | Excel Programming | |||
suppressing error message | Excel Programming | |||
Suppressing links message | Excel Programming |