Locked cells are still able to be selected with proper protection


J

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!
 
Ad

Advertisements

J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top