Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 2010 Tab make cursor move to spcific cell

Status
Not open for further replies.

joel009

Programmer
Jul 7, 2000
272
US
Hi,
Is there a method or a setting that will, when the user presses the Tab key to have the cursor or focus move to a specific cell? I've been searching the forum and Help and can't figure it out.

I am looking for something similar, I think, to the Tab Stop in Access but may be way off, more used to working in Access than Excel.
Thanks

Joel
 



If you 1) UNLOCK the cells that the user can select and then 2) PROTECT the sheet, then 3) TAB will go from cell to cell.

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Wow that was fast Skip! Got that working fine, it's been a long time since I worked in Excel.
Thanks

Joel
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top