Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
protecting a worksheet
I have a worksheet that is is being proteted in code - in the workbook open
event. This was working well till recently - Users could only click on the cells that were unprotected. Now, users can click on any cell. What have I done wrong? Thanks in advance for your advice Habib -- www.DynExtra.com A resource for the Microsoft Dynamics Community Featuring FAQs, File Exchange and more Current member count: 40 -------------------------------------------- Share your knowledge. Add your favorite questions and answers Help add questions to this site! We want Your input. -------------------------------------------- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
protecting a worksheet
Hi Habib,
'--------------- I have a worksheet that is is being proteted in code - in the workbook open event. This was working well till recently - Users could only click on the cells that were unprotected. Now, users can click on any cell. What have I done wrong? '--------------- Post the protection code. --- Regards, Norman |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
protecting a worksheet
Thanks! that should do it - I'll try it tonight and post an update
Regards Habib -- www.DynExtra.com A resource for the Microsoft Dynamics Community Featuring FAQs, File Exchange and more Current member count: 40 -------------------------------------------- Share your knowledge. Add your favorite questions and answers Help add questions to this site! We want Your input. -------------------------------------------- "John Bundy" wrote in message ... add xlUnLockedCells With Worksheets(1) .EnableSelection = xlUnLockedCells .Protect Contents:=True, UserInterfaceOnly:=True End With this will not allow selection of protected cells -John "HSalim[MVP]" wrote: I have a worksheet that is is being proteted in code - in the workbook open event. This was working well till recently - Users could only click on the cells that were unprotected. Now, users can click on any cell. What have I done wrong? Thanks in advance for your advice Habib -- www.DynExtra.com A resource for the Microsoft Dynamics Community Featuring FAQs, File Exchange and more Current member count: 40 -------------------------------------------- Share your knowledge. Add your favorite questions and answers Help add questions to this site! We want Your input. -------------------------------------------- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting worksheet | Excel Worksheet Functions | |||
protecting the worksheet | Excel Worksheet Functions | |||
Protecting Worksheet | Excel Discussion (Misc queries) | |||
Protecting worksheet | Excel Programming |