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