Using tab key in protected worksheet

  • Thread starter Thread starter bev
  • Start date Start date
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.
 
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
 
Yes I have tried different workstations. The tab key works if the worksheet
is changed back to unprotected but not in the protected mode.
 
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
 
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
Excel Move or Copy Stopped Working? 0
Tab Key 1
Tabbing on a Protected worksheet 3
Protected worksheet and arrow keys 1
Protected Sheet TAB issue 4
Protected Worksheet Tab Order 1
SORT DATA ON A PROTECTED WORKSHEET! 2

Back
Top