EnableSelection = xlUnlockedCells, but then can't change locked cells
Posted by Geoff on January 02, 2002 5:45 AM
I have altered the EnableSelection in the WorkSheet Properties so only unprotected cells can be selected. However a combobox macro then falls over with "Runtime error 1004: unable to set the locked property of the Range class", when it tries to change protected cells to unprotected, via Selection.Locked = False.
I've tried putting a
.EnableSelection = xlNoRestrictions
at the start of the ComboBox macro, but still falls over. Does anyone have any suggestions to a solution/point out where I'm going wrong?