View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default

Assign this code to the workbook to go to Sheet1 cell A2 every time the
file opens.
Private Sub Workbook_Open()
Range(A2).Select
End Sub

Assign this code to Sheet1. It checks to see if a change was made to
specified cells, and moves to the next cell. Note the Target.Address
cell references must be all caps, in this format: $A$2

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$2" Then Range("F3").Select
If Target.Address = "$F$3" Then Range("B5").Select
If Target.Address = "$B$5" Then MsgBox "Done."
End Sub