Running macro on file open

[excelnerd]

When I open a particular excel file, I want to always have the cursor on a
specific worksheet. That is, I want the file to open in a particular
worksheet. How can I do that?

Many thanks in advance.

 

[Dave Peterson]

You could use a macro:

Option Explicit
Sub Auto_Open()
application.goto thisworkbook.worksheets("sheet9999").range("a1"), _
scroll:=true
End Sub

Change the sheet name and cell address to what you want.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Billy Liddel]

Private sub workbook_open()
application.goto sheets("Sheet1").range("a1")
exit sub

placed in the workbook module, Right-click the Excel icon by the file menu
and choose View code.

Peter

 

[excelnerd]

Thank you very much. It was really helpful.

You could use a macro:

Option Explicit
Sub Auto_Open()
application.goto thisworkbook.worksheets("sheet9999").range("a1"), _
scroll:=true
End Sub

Change the sheet name and cell address to what you want.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm