Tabbing Question

[Joann]

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

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

I

 

[Luke M]

When replying, do so in the same thread. By starting a new thread, you lose
information and the rest of use don't know what's going on.

VBA = Visual Basic for Applications.
It's the coding the Microsoft Office (and other applications) can use to
write macros, interact with other applications, and perform subroutines. You
can get to the editor either by pressing Alt+F11, or right-clicking on a
sheet tab and "view code".

In answer to you first main question, I'd simply unprotect (format
cells-protection, unlselect 'locked') the cells you want to Tab to, and then
protect the worksheet.

 

[Shane Devenshire]

Hi,

Please see the answers on your other thread. Don't break up your threads,
we don't have time to figure out where something came from.

 

[Joann]

Luke...I have created this range of cells....what do I need to do in order to
have the worksheet open & have this range selected so that I only tab through
that range?

Is this where I lock the other cells? I am confused....
Please help....

Jo

 

[Joann]

I have created this range of cells....what do I need to do in order to
have the worksheet open & have this range selected so that I only tab through
that range?

Is this where I lock the other cells? I am confused....
Please help....

Jo

 

[Otto Moehrbach]

Joann
What did you name the range? Do you want the selection made when you
open the workbook (the file), or do you want the selection made when you (or
the user) selects that sheet? What is the name of the sheet? HTH Otto

 

[Joann]

I named this function TheRng5. There is only one worksheet in this file.
When this file or sheet since it is the only one is opened, I want this range
to automatically be selected so that i don't have to hit the F5 key in order
to enable it.

Please help....thanks!
Joann

 

[Otto Moehrbach]

Joann
This macro will do what you want. I also added a scroll command to
place the top-left cell of the range at the top-left corner of the screen.
Selecting a range with VBA does not necessarily place the range, or any part
of it, in the visible screen. It does that with the scroll command I added.
Private Sub Workbook_Open()
Range("TheRng5").Select
With ActiveWindow
.ScrollColumn = Range("TheRng5")(1).Column
.ScrollRow = Range("TheRng5")(1).Row
End With
End Sub
Note that this macro must be placed in the Workbook module. To access that
module, right-click on the Excel icon that is immediately to the left of the
word "File" in the menu that runs across the top of your screen, and select
View Code. Paste this macro into that module. "X" out of the module to
return to your sheet. If you are working with Excel 2007 it's a bit more
complicated if you are not familiar with using VBA. In that case, if you
wish, send me your file or a small sample of your file and I'll place the
macro for you. My email address is (e-mail address removed). Remove
the "extra" from this address. HTH Otto