Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turning Off Protection Notification
Excel 2003. I am producing a worksheet that is protected. However, I do not
want to see the warning about a protected cell everytime someone tries to type in it. Instead, I simply want them not to be able to type. The message I am getting and do NOT want is: The cell or chart you are trying to change is protected and therefore read-only Again, how do I make it so that the message does not come up, but that people simply cannot type in or change the sheet or protected cells? Thanks for the help. -- Dr. Doug Pruiett Good News Jail & Prison Ministry www.goodnewsjail.org |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turning Off Protection Notification
You can't change the message, but you can stop them from selecting locked cells
on a protected sheet. Option Explicit Sub auto_open() Dim wks As Worksheet Set wks = Worksheets("sheet1") With wks .Protect password:="hi" .EnableSelection = xlUnlockedCells End With End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Excel doesn't remember this setting--so the code uses the auto_open procedure to set it each time the workbook opens. Chaplain Doug wrote: Excel 2003. I am producing a worksheet that is protected. However, I do not want to see the warning about a protected cell everytime someone tries to type in it. Instead, I simply want them not to be able to type. The message I am getting and do NOT want is: The cell or chart you are trying to change is protected and therefore read-only Again, how do I make it so that the message does not come up, but that people simply cannot type in or change the sheet or protected cells? Thanks for the help. -- Dr. Doug Pruiett Good News Jail & Prison Ministry www.goodnewsjail.org -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turning Off Protection Notification
Thank you for the help Dave. God bless.
-- Dr. Doug Pruiett Good News Jail & Prison Ministry www.goodnewsjail.org "Dave Peterson" wrote: You can't change the message, but you can stop them from selecting locked cells on a protected sheet. Option Explicit Sub auto_open() Dim wks As Worksheet Set wks = Worksheets("sheet1") With wks .Protect password:="hi" .EnableSelection = xlUnlockedCells End With End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Excel doesn't remember this setting--so the code uses the auto_open procedure to set it each time the workbook opens. Chaplain Doug wrote: Excel 2003. I am producing a worksheet that is protected. However, I do not want to see the warning about a protected cell everytime someone tries to type in it. Instead, I simply want them not to be able to type. The message I am getting and do NOT want is: The cell or chart you are trying to change is protected and therefore read-only Again, how do I make it so that the message does not come up, but that people simply cannot type in or change the sheet or protected cells? Thanks for the help. -- Dr. Doug Pruiett Good News Jail & Prison Ministry www.goodnewsjail.org -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error when save as CSV with VBA password protection on | Excel Discussion (Misc queries) | |||
No "File in use" notification | Excel Discussion (Misc queries) | |||
VBA code error with Protection turned on - help please | Excel Discussion (Misc queries) | |||
Three levels of protection in one worksheet | Excel Worksheet Functions | |||
workbook protection | New Users to Excel |