Excel program

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

I have a simple program in excel for data entry. When I
protect the sheet, and use tab to move about within the
spreadsheet, sometimes the tab button will not move the
cursor to the next cell. It will pick a random cell to go
to next. Is there a way that I can designate what cell it
will go to next. Thanks for your help, jb
 
On a protected sheet, it is going to the next unprotected cell. So, if you
don't want it to go to a cell, protect it.
 
Gord Dibben has posted this workaround that might be something you can use:
http://google.com/[email protected]

He suggests selecting the range (in a specific order), giving it a nice range
name and then selecting that range when you want to follow a specific tab order.
 
Back
Top