Hi,
Having trouble protecting locked cells in a spreadsheet I create with
an Access proc. I locked the cells with:
objSht.Range(A1:C11).Select 'Select and lock range
Selection.Locked = True
Selection.FormulaHidden = False
Then protected the spreadsheet specifying that users shouldn't be able
to select locked cells:
.ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True 'lock Sheet
.ActiveSheet.EnableSelection = xlUnlockedCells
The spreadsheet is "protected", but both locked and unlocked cells are
enabled. That is, for some reason locked cells are also enabled.
Any clues?
