When you protect sheet, by default two options are selected and those options
allow user to select locked cells.

Go to Tools - Protection - Protect Sheet, in that you'l find list of
options underneath "Allow all users of this worksheet to:" deselect following
options from list
1. Select locked cells
2. Select unlocked cells

Hope this helps !!!

"Corey" wrote:

Currently use:

ActiveSheet.protect DrawingObjects:=True, Contents:=True, Scenarios:=False,
AllowFormattingCells:=True


It ALLOWS the user to Select LOCKED Cells still.

How can i have the Cells that are LOCKED to NOT be ENABLED,

Yet have them still able to Select UNLOCKED Cells and be able to Format the Unlocked Cells too?

Is there a :
LockedCellsSelect:=False ?


Corey....