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....

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....
>
>
>

Thanks for the reply.
Yes i can MANUALLY change the Locked Cells to Not be able to be selected.
But i want to do this with code.
As i leave the workbook (Close it) and when i open it it reverts back to
Locked cells being able to be selected again.

Corey....
"Himani" <(E-Mail Removed)> wrote in message
news:2861F8FB-1A20-4C26-9ABD-(E-Mail Removed)...
> 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....
>>
>>
>>

ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
ActiveSheet.EnableSelection = xlNoSelection

"Coza" wrote:

> Thanks for the reply.
> Yes i can MANUALLY change the Locked Cells to Not be able to be selected.
> But i want to do this with code.
> As i leave the workbook (Close it) and when i open it it reverts back to
> Locked cells being able to be selected again.
>
> Corey....
> "Himani" <(E-Mail Removed)> wrote in message
> news:2861F8FB-1A20-4C26-9ABD-(E-Mail Removed)...
> > 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....
> >>
> >>
> >>
>
>
>

Or
.EnableSelection = xlUnlockedCells

Excel won't remember these settings after you close it and reopen the workbook
(so put it in your auto_open or workbook_open procedure)

Himani wrote:
>
> ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
> ActiveSheet.EnableSelection = xlNoSelection
>
> "Coza" wrote:
>
> > Thanks for the reply.
> > Yes i can MANUALLY change the Locked Cells to Not be able to be selected.
> > But i want to do this with code.
> > As i leave the workbook (Close it) and when i open it it reverts back to
> > Locked cells being able to be selected again.
> >
> > Corey....
> > "Himani" <(E-Mail Removed)> wrote in message
> > news:2861F8FB-1A20-4C26-9ABD-(E-Mail Removed)...
> > > 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....
> > >>
> > >>
> > >>
> >
> >
> >

--

Dave Peterson