View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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?