Have cursor go to specific place when worksheet opens?
 

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

Have cursor go to specific place when worksheet opens?
 

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



" wrote:

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