How do I do Auto_Activate Macro?
 

Hi!
Is there anyone willing to give some advice?

Im trying to create a Macro in Excel2000 that should start
when the workbook is opened. It should make sure
calculations are automatic and Iteration is enabled.

Ive tried to record a macro and name it Auto_Activate it
doesnt seem to run when I open Excel.

How should I do this? Ive tried to research this from MSN
support pages, but I havent found anything.
regards
/Bernhard, Stockholm

How do I do Auto_Activate Macro?
 

Hi Bernhard
use either the workbook_open event (in your workbook module) or name
your macro Auto_Open()

--
Regards
Frank Kabel
Frankfurt, Germany


Bernhard wrote:
Hi!
Is there anyone willing to give some advice?

Im trying to create a Macro in Excel2000 that should start
when the workbook is opened. It should make sure
calculations are automatic and Iteration is enabled.

Ive tried to record a macro and name it Auto_Activate it
doesnt seem to run when I open Excel.

How should I do this? Ive tried to research this from MSN
support pages, but I havent found anything.
regards
/Bernhard, Stockholm

How do I do Auto_Activate Macro?
 

http://www.cpearson.com/excel/events.htm

at Chip Pearson's site for information on Events.

--
Regards,
Tom Ogilvy


"Frank Kabel" wrote in message
...
Hi Bernhard
use either the workbook_open event (in your workbook module) or name
your macro Auto_Open()

--
Regards
Frank Kabel
Frankfurt, Germany


Bernhard wrote:
Hi!
Is there anyone willing to give some advice?

Im trying to create a Macro in Excel2000 that should start
when the workbook is opened. It should make sure
calculations are automatic and Iteration is enabled.

Ive tried to record a macro and name it Auto_Activate it
doesnt seem to run when I open Excel.

How should I do this? Ive tried to research this from MSN
support pages, but I havent found anything.
regards
/Bernhard, Stockholm