Hello Smallville,
This macro will direct the tabbing to the cells of your choosing. Just enter the cell addresses you want into the macro (marked in blue). You can edit this later if you need to add or remove to change the tabbing order. This will move from to cell C5 on the first tab, C7 on the second, B2 on the third, H5 on the foruth, and starts over at C5. You will need to install this macro on each sheet you want to control tabbing on.
How to Save a Worksheet Event Macro
1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on the Worksheet's Name Tab for the Worksheet the macro will run on.
3. Left Click on View Code in the pop up menu.
4. Paste the macro code using CTRL+V
5. Save the macro in your Workbook using CTRL+S
Sincerely,
Leith Ross
Bookmarks