🚀 go-pugleaf

Steve,
Call the macro Auto_Open as in
Sub Auto_Open()

< code>

End Sub

Olav
They ain't making bugs like Bunny anymore

On Tue, 11 Nov 97 08:08:11 GMT, stevebo@onramp.net (Steve Silberberg)
wrote:

>I cannot for the life of me figure out how to get Excel to run a Macro at 
>start up.  It's not anywhere in the on-line documentation, although the 
>documentation says to press "Shift" to cancel the mysterious macro.
>
>How do you do it?
>Steve "Whatever happened to auto123.wk1 anyway?" Silberberg
>
>----------------
>Steve Silberberg
>mailto:stevebo@onramp.net
>Visit the Air Sickness Bag Museum at:
>http://rampages.onramp.net/~stevebo/airsick.html
>FACT:  Buff Babes Dig Cut Dudes!

Steve Silberberg wrote:
> 
> I cannot for the life of me figure out how to get Excel to run a Macro at
> start up.  It's not anywhere in the on-line documentation, although the
> documentation says to press "Shift" to cancel the mysterious macro.
> 
> How do you do it?
> Steve "Whatever happened to auto123.wk1 anyway?" Silberberg
> 
> ----------------
> Steve Silberberg
> mailto:stevebo@onramp.net
> Visit the Air Sickness Bag Museum at:
> http://rampages.onramp.net/~stevebo/airsick.html
> FACT:  Buff Babes Dig Cut Dudes!
To run the macro on opening a workbook, simply call it Auto_Open(). I
assume this is the function you're talking about.
-- 
      ___                         
   __|   |_______ ______  ___  ______
 /   _   |   _   |    _  \\  \/  /   |		Send E-Mail to:
|  ( _|  |   _   |   |_) / |    ||   |___	x!daryl_crich@amp.com.au!x
 \ ______|__| |__|___|\___\|____||_______|	(remove !x - I hate spam!)

In Excel97, attach to the workbook object:
Private Sub Workbook_Open()

End Sub
 When you "view code" for the workbook object (select in your project
window;hit view code), the module is blank.  Select the dropdown arrow on the
left and then select workbook.  The above code should appear.  In any case, the
dropdown arrow on the right will now show the events associated with the
workbook.

Daryl Crich wrote:

> Steve Silberberg wrote:
> >
> > I cannot for the life of me figure out how to get Excel to run a Macro at
> > start up.  It's not anywhere in the on-line documentation, although the
> > documentation says to press "Shift" to cancel the mysterious macro.
> >
> > How do you do it?
> > Steve "Whatever happened to auto123.wk1 anyway?" Silberberg
> >
> > ----------------
> > Steve Silberberg
> > mailto:stevebo@onramp.net
> > Visit the Air Sickness Bag Museum at:
> > http://rampages.onramp.net/~stevebo/airsick.html
> > FACT:  Buff Babes Dig Cut Dudes!
> To run the macro on opening a workbook, simply call it Auto_Open(). I
> assume this is the function you're talking about.
> --
>       ___
>    __|   |_______ ______  ___  ______
>  /   _   |   _   |    _  \\  \/  /   |          Send E-Mail to:
> |  ( _|  |   _   |   |_) / |    ||   |___       x!daryl_crich@amp.com.au!x
>  \ ______|__| |__|___|\___\|____||_______|      (remove !x - I hate spam!)

In Excel97, attach to the workbook object:
Private Sub Workbook_Open()

End Sub
 When you "view code" for the workbook object (select in your project
window;hit view code), the module is blank.  Select the dropdown arrow on the
left and then select workbook.  The above code should appear.  In any case, the
dropdown arrow on the right will now show the events associated with the
workbook.

Daryl Crich wrote:

> Steve Silberberg wrote:
> >
> > I cannot for the life of me figure out how to get Excel to run a Macro at
> > start up.  It's not anywhere in the on-line documentation, although the
> > documentation says to press "Shift" to cancel the mysterious macro.
> >
> > How do you do it?
> > Steve "Whatever happened to auto123.wk1 anyway?" Silberberg
> >
> > ----------------
> > Steve Silberberg
> > mailto:stevebo@onramp.net
> > Visit the Air Sickness Bag Museum at:
> > http://rampages.onramp.net/~stevebo/airsick.html
> > FACT:  Buff Babes Dig Cut Dudes!
> To run the macro on opening a workbook, simply call it Auto_Open(). I
> assume this is the function you're talking about.
> --
>       ___
>    __|   |_______ ______  ___  ______
>  /   _   |   _   |    _  \\  \/  /   |          Send E-Mail to:
> |  ( _|  |   _   |   |_) / |    ||   |___       x!daryl_crich@amp.com.au!x
>  \ ______|__| |__|___|\___\|____||_______|      (remove !x - I hate spam!)