Turning WorkSheet Protection On

[jgupte]

I am turning the protection on my worksheet off so I can modify cells, then turning it on again. However when I turn it back on, locked cells can sometimes be selected (but not updated).

The code I am using is

ActiveSheet.Protect Contents:=True

Can anybody tell me what I am doing wrong?

[Paul]

Hi Jgupte,

Try adding this line before your 'Protect Contents:=True' line:

Please Login or Register  to view this content.

[jgupte]

Seems to work.

Many thanks.