How do you get a macro to run upon opening a SpSheet

K

Kate

Hi,

I have a macro already built into the spreadsheet, but I
need to add a code that would make the macro run when the
spreadsheet is initially opened by the user.

Any ideas???

Thanks.
Kate
 
S

Stephen Rasey

When the Spreadsheet is Activated
Or when the Workbook is Opened?
You probably mean the latter, but it matters.

In the Visual Basic Editor, Project Window,
Right click on the ThisWorkbook item. (it is just above the Modules
folder).
Choose View Code
It will be blank.
In the left drop down box in the Edit window (it will say "(General)"),
choose Workbook.
In the right Drop Down, Choose Open (by default.

Private Sub Workbook_Open()
MyMacro
End Sub

A word of advice. Almost all you VBA in the Modules. Only put calls to
modules in the this "code behind".

Stephen Rasey
Houston
http://wiserways.com
http://excelsig.org
 
K

Kris

Hello Kate,

Name your macro Auto_Open

i.e.

Sub Auto_Open()
'your code
End Sub

Hope this helps,

Kris
 
R

Ron de Bruin

Hi Kate

Sub Auto_open()
MsgBox "Hi"
End Sub

Must be in a normal module
If you use a Auto_open macro then this wil not run if you open the file with a macro


Private Sub Workbook_Open()
Msgbox "Workbook Opened"
End Sub

Must be in the Thisworkbook module
 
F

Frank Stone

hi,
yes. move the code to the workbooks Open event.
open the workbook. then open VB editor. open the module
your code is in. copy it. in the project pane, douple
click this workbook. above the code window, click the righ
box,select workbook. on the left side box , click open.
Paste your code in the code window.
the macro should fire when the work book is opne.
 
T

Tom Ogilvy

Workbook_open wasn't introduced until xl97. xl5 and xl95 used Auto_open and
Auto_close. Before that, the xl4 macro language used Auto_open xl4 macros.
 
Top