Anyone got any ideas on how to preset a tabulation order in excel. Cant find it anywhere.
S SYBS Jul 4, 2005 #1 Anyone got any ideas on how to preset a tabulation order in excel. Cant find it anywhere.
A Anne Troy Jul 4, 2005 #2 If you unprotect only the cells you want to tab to, and then protect the worksheet, your tab order is set. If you have some other need, please explain in more detail. http://www.officearticles.com/excel/cell_locking_in_microsoft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com
If you unprotect only the cells you want to tab to, and then protect the worksheet, your tab order is set. If you have some other need, please explain in more detail. http://www.officearticles.com/excel/cell_locking_in_microsoft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com
B Bob Phillips Jul 4, 2005 #4 See http://www.xldynamic.com/source/xld.xlFAQ0008.html -- HTH RP (remove nothere from the email address if mailing direct)
See http://www.xldynamic.com/source/xld.xlFAQ0008.html -- HTH RP (remove nothere from the email address if mailing direct)
G Gord Dibben Jul 4, 2005 #5 Several ways to do this. See the info here at Bob Phillips' site. http://www.xldynamic.com/source/xld.xlFAQ0008.html There is another method which involves VBA Worksheet event code. If interested in that, post back. Gord Dibben Excel MVP
Several ways to do this. See the info here at Bob Phillips' site. http://www.xldynamic.com/source/xld.xlFAQ0008.html There is another method which involves VBA Worksheet event code. If interested in that, post back. Gord Dibben Excel MVP