control cell tab order

[Joy Caldwell]

In an archived thread, I found a response to another user's question on how to control the cell tab order on a locked work sheet. However, I can't seem to find the VBA example called out in the posting. Can someone help me locate this file?

CellTabControl_VBA.xls

Thanks,
Joy

[TryingToLearn]

Not sure where that might be but this is what I use:

Option Explicit
Public aut As String
Public curmove, ckwkly As Boolean
Public curdirec As Long

Private Sub Worksheet_Activate()
    curmove = Application.MoveAfterReturn
    curdirec = Application.MoveAfterReturnDirection
    Application.MoveAfterReturn = True
    Application.MoveAfterReturnDirection = xlDown
    aut = Application.EnableAutoComplete
    Application.EnableAutoComplete = False
End Sub


Private Sub Worksheet_Deactivate()
        Application.MoveAfterReturnDirection = curdirec
        Application.MoveAfterReturn = curmove
        If aut <> Empty Then Application.EnableAutoComplete = aut
End Sub

HTH