Right click sheet tabview code insert thistest and modify to suit.
OR unlock desired cellsprotect sheetuse tab key
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("a3").Address Then Range("b3").Select
If Target.Address = Range("b3").Address Then Range("b13").Select
'etc
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"SFTaxMan" wrote in message
...
Does anybody know how to set a "tab order" in Excel 2003 for PC? I'm not
talking about just tabbing from left to right, but how to set a custom tab
order -- to tab to a pre-designated cell.
thanx,
Cliff
San Francisco