Hi folks,
I used the code below to protect a sheet:
ActiveSheet.EnableSelection = xlNoSelection
ActiveSheet.Protect Password:="CADEMP"
It works properly. I tested it after running the code.
But when I save the worksheet and reopen it I CAN select the cells. It
seems that the code was not effective.
But when I do the same procedure using the Excel menu
(Tolls/Protect/...) and save, when a reopen the woksheet it works
properly.
Do some of you know how to avoid the problem?
Thanks,
Marcelo Rychter
--
Marcelo Rychter
------------------------------------------------------------------------
Marcelo Rychter's Profile:
http://www.excelforum.com/member.php...o&userid=35066
View this thread:
http://www.excelforum.com/showthread...hreadid=557625