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?
Bookmarks