M
Maistrye
I have a macro to automatically protect my sheets. This macro i
designed to only allow the selection of Unlocked Cells.
ActiveSheet.Protect "a"
ActiveSheet.EnableSelection = xlUnlockedCells
It works fine for every sheet I've used it on up until I re-load i
after I've saved it. (Namely, the locked cells can't be selected, bu
the unlocked ones can.)
When I re-open the workbook, the sheet is still protected, but I ca
select Locked Cells and Unlocked Cells. (Only the Unlocked ones can b
editted, of course.)
Does anyone know of a way to fix this? ie. Change my macro so tha
this problem does not occur?
Thanks,
Scot
designed to only allow the selection of Unlocked Cells.
ActiveSheet.Protect "a"
ActiveSheet.EnableSelection = xlUnlockedCells
It works fine for every sheet I've used it on up until I re-load i
after I've saved it. (Namely, the locked cells can't be selected, bu
the unlocked ones can.)
When I re-open the workbook, the sheet is still protected, but I ca
select Locked Cells and Unlocked Cells. (Only the Unlocked ones can b
editted, of course.)
Does anyone know of a way to fix this? ie. Change my macro so tha
this problem does not occur?
Thanks,
Scot