Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting cell selections in form spreadsheet
I am trying to get my tab button to jump to the unlocked cells only so that
the user can go straight to the cells that they need to populate on my form created in Excel. Can anyone help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting cell selections in form spreadsheet
Lock all cells except the ones you want to Tab into.
Protect the worksheet. Tabbing will move you across then down then across. If not in that order post back. Gord Dibben MS Excel MVP On Tue, 9 Jun 2009 19:23:01 -0700, kentuckyjo wrote: I am trying to get my tab button to jump to the unlocked cells only so that the user can go straight to the cells that they need to populate on my form created in Excel. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel form. Need data extracted to spreadsheet each time a form co | Excel Discussion (Misc queries) | |||
Setting up a form | Excel Discussion (Misc queries) | |||
Setting up a Form | Excel Discussion (Misc queries) | |||
Setting up MS Excel form | Excel Worksheet Functions | |||
Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) |