View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Focus On Open - Goto

Hi,

ALT+F11 to open vb editor. Double click 'Thisworkbok' and paste the code
below in on the right

Private Sub Workbook_Open()
Application.Goto Sheets(1).Range("A1")
End Sub

Mike

"chickalina" wrote:

I am trying to figure out a way to do this in Excel.
I would like the focus to be on the first cell of the first worksheet when
the workbook is opened - every time.
Can this be done in VBA?
Thanks for any help.