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.
--------------------------------------------