Cell Navigation
how can i force cell navigation in a specific order via the tab key? i have
done this before but it has been a while and i can't remember how i did it. thanks for helping. |
Cell Navigation
Lock all cells on a sheet (they are by default).
Then unlock the cells you want to be able to automatically navigate to, and Protect the sheet, unchecking the option permitting users to select Locked cells. I hope that's what you're looking for. "LaDonna" wrote: how can i force cell navigation in a specific order via the tab key? i have done this before but it has been a while and i can't remember how i did it. thanks for helping. |
Cell Navigation
See Jerry's reply about tabbing to unlocked cells on a protected sheet.
Note that Tab order to unlocked cells is always left to right then down, left to right. If you have some other Tab order you will need a named range or VBA. See Bob Phillips' site creating a named range. http://www.xldynamic.com/source/xld.xlFAQ0008.html If you want to entertain VBA method, post back. Gord Dibben MS Excel MVP On Thu, 25 Mar 2010 08:33:01 -0700, LaDonna wrote: how can i force cell navigation in a specific order via the tab key? i have done this before but it has been a while and i can't remember how i did it. thanks for helping. |
All times are GMT +1. The time now is 06:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com