You could use a named range.

See Bob Phillips' site for instructions.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

Or use event code.

Private Sub Worksheet_Change(ByVal Target As Range)
'Anne Troy's taborder event code
Dim aTabOrd As Variant
Dim i As Long

'Set the tab order of input cells
aTabOrd = Array("A5", "B5", "C3", "A10", "C10", "A4")

'Loop through the array of cell address
For i = LBound(aTabOrd) To UBound(aTabOrd)
'If the cell that's changed is in the array
If aTabOrd(i) = Target.Address(0, 0) Then
'If the cell that's changed is the last in the array
If i = UBound(aTabOrd) Then
'Select first cell in the array
Me.Range(aTabOrd(LBound(aTabOrd))).Select
Else
'Select next cell in the array
Me.Range(aTabOrd(i + 1)).Select
End If
End If
Next i

End Sub


Gord Dibben MS Excel MVP

On Thu, 4 Dec 2008 07:11:02 -0800, CONFUSED AT WORK
wrote:

Just windering if there is a way to tab through a locked sheet. I have many
unlocked cells, that i need access to, but the problem is I need them in a
specific order, for example, right now its,

a1 - tab b1 tab c1

Where i Need it a1 tab c3 tab b2

Didnt know if there was a way or not.


THanks.