Locked cells are still able to be selected with proper protection

[Jesse]

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!

 

[Jesse]

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