Automatically executing a subroutine/macro when opening a file

[rendezvous]

How do you get an excel file to automatically launch a macro as soon as the file is opened?

thanks

 

[TonyU]

[tt]Here are two example macros that will run as soon as excel opens:

This macro opens the workbook at sheet 1 even if you save it at page 100
1.
Option Explicit
Private Sub Workbook_Open()
Worksheets("Sheet1&quot.Select
Application.Goto Reference:="Cell Location"
End Sub


This macro opens your document at 80% it's size
2.
Private Sub Workbook_Open()
ActiveWindow.Zoom = 80
End Sub

T ® Ñ ¥
To keep a lamp burning we have to keep puting oil in it.

​

 

[RobBroekhuis]

You can't put these subs just anywhere - they belong in the code for the workbook object. Double-click on the workbook name in the VBE project explorer (top left of VBE screen) to get to that code module, and then create your workbook_open sub there.
Rob

 

[TonyU]

Oops, forgot to mention that.... Thanks

T ® Ñ ¥
To keep a lamp burning we have to keep puting oil in it.

​