Have cursor go to specific place when worksheet opens?

R

RJQMAN

Is there any way to make the cursor go to a specific cell every time
the user accesses that worksheet from a sheet tab?
 
F

FSt1

hi
this is worksheet code. right click the tab then click view code.
in the left drop down above the code window, click and select worksheet.
the worksheet change event should default into the code window. delete it.
paste this.
Private Sub Worksheet_Activate()
Range("A1").Select 'Adjust to suit
End Sub

regards
FSt1
 
Top