Using tab key in protected worksheet

B

bev

I have a worksheet that I am allowing users to edit only certain cells. In
the protected mode, the tab key won't work, only the arrows and enter key.
Any ideas what I need to get this function back? Thank you.
 
G

Gord Dibben

You have some cells that are unlocked and you want to Tab to those cells?

I don't know why your Tab key will not do that.

Have you tried a different keyboard?


Gord Dibben MS Excel MVP
 
B

bev

Yes I have tried different workstations. The tab key works if the worksheet
is changed back to unprotected but not in the protected mode.
 
G

Gord Dibben

In sheet protection did you check the "select unlocked cells" under "allow
user to:"

I'm out of ideas.............Tab key has always worked for me on a protected
sheet.


Gord
 
B

bev

Yes I have this checked.

Gord Dibben said:
In sheet protection did you check the "select unlocked cells" under "allow
user to:"

I'm out of ideas.............Tab key has always worked for me on a protected
sheet.


Gord
Click to expand...
 

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

Similar Threads

Protected worksheet/tab key 2
SORT DATA ON A PROTECTED WORKSHEET! 2
Protected Worksheet Tab Order 1
allow a user to edit ranges in a protected worksheet 3
How can I merge unprotected cells in a protected worksheet? 1
Tabbing on a Protected worksheet 3
Insert/ delete row in protected worksheet 7
Using Group and Outline with Protected Cells 1

Top