Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Changing Tab Order
Posted by Becky S. on August 17, 2001 12:14 PM
I have an excel worksheet in which I would like to change the tab order. For instance, instead of going from cell A1 to cell B1 upon hitting tab, I would like it to go from cell A1 to cell C1. Does anyone know of a way to do this?
Re: Changing Tab Order
Posted by phillip on August 17, 2001 12:14 PM
Re: Changing Tab Order
Posted by phillip on August 17, 2001 12:24 PM
Oops. My bad. I thought you were talking about Worksheet Tabs. I don't know how to do what you want....except maybe hit"tab" twice ?
Re: Changing Tab Order
Posted by lenze on August 17, 2001 12:45 PM
It sounds like you may have a form you wish to navigate. If so, you should lock all cells on the sheet (Format>Cell>Protection Tab) and then unlock cells you want to be able to change or enter data in. Then, protect the worksheet. Now the TAB key will move from one unlocked cell to the next, skipping the locked ones.
Re: Changing Tab Order
Posted by lenze on August 17, 2001 12:45 PM
It sounds like you may have a form you wish to navigate. If so, you should lock all cells on the sheet (Format>Cell>Protection Tab) and then unlock cells you want to be able to change or enter data in. Then, protect the worksheet. Now the TAB key will move from one unlocked cell to the next, skipping the locked ones.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.