Can't use tab after protecting sheet.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I have password protected a sheet in an Excel 2003 workbook. Now, I can't
use the TAB button to move to the next cell. The ENTER button and the arrow
buttons work.
Is there a way to get the TAB button working again?
Thanks
 
Hi

the TAB key will work if you have some "unprotected" cells - it will move
through them in turn to enable data entry. If your entire sheet is "locked"
and nothing can be changed on it, then AFAIK you can't enable the TAB key.

Cheers
JulieD
 
Thanks for the help.

JulieD said:
Hi

the TAB key will work if you have some "unprotected" cells - it will move
through them in turn to enable data entry. If your entire sheet is "locked"
and nothing can be changed on it, then AFAIK you can't enable the TAB key.

Cheers
JulieD
Click to expand...
 
You must log in or register to reply here.

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

Excel Move or Copy Stopped Working? 0
Protected Worksheet Tab Order 1
Excel Protection 2
Grayed out Tab in Excel 1
navigation keys in protected sheet 1
Sheet tab names change automatically 3
Not a novice - can't delete tabs! 1
Oversensitive touchpad on modern laptops 0

Back
Top