Tabbing Question

  • Thread starter Thread starter Joann
  • Start date Start date
J

Joann

I have a worksheet that I am putting together & when I tab through it, I only
want it to tab to the cells that I need to be completed by others (as opposed
to going to every cell). Is there a way that i can set this worksheet up to
where it will only do this?


Thanks!
Jo
 
Hi Jo,
Unprotect the cells where you want the users to navigate and then protect
the worksheet the tab will only go to the unprotected cells
If this was helpful please say yes
 
The method given you by Eduardo is one way. The only drawback I know of
that method is that the order of cell selection cannot be controlled by you
or the user. Cell selection will be by rows and then by columns.
Another way is to select the cells in which you want the user to enter
data and name that range, say TheRng. The sequence of cell selection by you
when you name the range is the key to the sequence of cell selection by the
user. Here is how you do it. Click on the second cell in the sequence you
want. Now hold down the Ctrl key and select all the other cells in the
sequence you want ending up with the first cell in the sequence. Release
the Ctrl key and name that range. Now if you hit the F5 key, click on
TheRng - OK, all those cells will be selected and the first cell in the
sequence will be the active cell. Hitting the tab key will move the
selection to the next cell in the order you chose. The only drawback to
this method is that the range has to be selected. I don't know how you will
be using this but you might consider VBA to automatically select the range
when the workbook is opened or that sheet is selected. HTH Otto
 
Hi,

You can refine the suggestion by Eduardo to solve the problem mentioned by
Otto:

When you choose Tools, Protection Worksheet, uncheck the Select locked cells
option. Now when you are in the data entry range Tab will move you one way
but you can also use Shift Tab, Enter and Shift Enter to move in various
other ways.

If none of these methods suit your needs you can write a VBA routine to move
through any set of cells in any order you wish.
 
Ok, i did this, & I do want it to automatically come up when the sheet is
open. What does VBA mean? How do i get this to work?
Jo
 
Hi,

It means that if none of the solutions work, then you could consider
programming the sequence you want the cursor to move. VBA stands for Visual
Basic for Applications, here Excel. This means you are creating and using a
program written by you or someone else. For moving around in the spreadsheet
I generally think this is overkill.

If you wanted this you would need to post the exact order you want the
cursor to move and what you want the program to do if the user want to
override the programmed behavor, for example they missed a cell.
 
Back
Top