Tab order

  • Thread starter Thread starter Candee
  • Start date Start date
C

Candee

Good morning all

Is it possible to set the tab order of a worksheet to skip over a
certain column (H) unless you specifically click on the cell with the
mouse? My spreadsheet is already set up, so I don't want to have to
move the locations of the information that is already in the columns.


Thanks for any insight.....
 
Candee

You can Protect the sheet and this will prevent the user
entering data in prtected cell. Using the Tab key will
just skip over the column or row that is protected.

Before you protect the sheet you must unlock the cells
that will be edited. Select these cells and Choose Format,
Cells, and on the Protection Tab click on the Locked check
box.

Alternatively, you can hide the column(s) and restore this
prior to print. someone will write you a macro to do this
if youo choose this method

Hope this helps
Peter
 
I don't know the answer to that, but i would be interested in knowing
how to do that as well.

djeans
 
Candee

One method.......

CRTL + A to select all cells.

Format>Cells>Protection. Un-check "locked".

Select Column H.

Format>Cells>Protection. Re-check "locked".

Tools>Protection>Protect Sheet.

If using XL2002 you can allow users to edit ranges. Column H in this case.

Gord Dibben XL2002
 
Thanks, Gord,

That would work well if the column didn't need to be accessed at all.
Maybe more detail would help...I have set up code for Column H that
pops up a message box asking for a number of hours, does a calculation,
and enters that number in the active cell in column H. Not every
record on the spreadsheet will need an entry in that column, and the
user entering the data uses the tab button to move across the sheet to
enter his data. The code below allows him to just hit the enter key
when he gets the column H and continue on, but I was hoping there might
be a way to skip over the column completely, and when he needs to make
an entry there he can click on the cell with the mouse.




Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

Dim Hrs As Double

If Target.Column = 8 Then
Hrs = Application.InputBox("Enter # of Rework ours", "Rework
Hours", Cancel, 0)

If Hrs <> 0 Then
Target.Value = Hrs * 64.8
End If
End If

End Sub
 
Back
Top