An excel worksheet I'm developing has rows that alternates between locked and
unlocked cells. When I protect the worksheet with the option for users to
select unlocked cells and format cells checked I'm still able to select and
format locked cells by drag the cursor vertically from one unlocked cell to
another. Is there a way to prevent this from happening?

Any help would be appreciated!

Hi Jesse
Select the whole w/sheet < format < format cells < protection < uncheck then
check locked < ok
Select the areas you need to allow access
Format < format cells < uncheck the box <ok
As you know it won't work without protection so, on Review tab < changes <
protect sheet < set password < ok

If this w/book is shared from a common drive then set it as a shared w/book.
Review tab < changes < share w/b < check allow users < saves on exit

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Jesse" wrote:

An excel worksheet I'm developing has rows that alternates between locked and
unlocked cells. When I protect the worksheet with the option for users to
select unlocked cells and format cells checked I'm still able to select and
format locked cells by drag the cursor vertically from one unlocked cell to
another. Is there a way to prevent this from happening?

Any help would be appreciated!

Russell,

Thank you for trying to help, but it didn't work. I'm still able to select
locked and protected cells. When I place the cursor on an unlocked cell and
drag it vertically to another unlocked cell the locked cells in-between
become selected and can be modified and saved. I had a similar worksheet back
on Office 2003 and it worked correctly.

Jesse

"Russell Dawson" wrote:

Hi Jesse
Select the whole w/sheet < format < format cells < protection < uncheck then
check locked < ok
Select the areas you need to allow access
Format < format cells < uncheck the box <ok
As you know it won't work without protection so, on Review tab < changes <
protect sheet < set password < ok

If this w/book is shared from a common drive then set it as a shared w/book.
Review tab < changes < share w/b < check allow users < saves on exit

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Jesse" wrote:

An excel worksheet I'm developing has rows that alternates between locked and
unlocked cells. When I protect the worksheet with the option for users to
select unlocked cells and format cells checked I'm still able to select and
format locked cells by drag the cursor vertically from one unlocked cell to
another. Is there a way to prevent this from happening?

Any help would be appreciated!