How do I do Auto_Activate Macro?

[Bernhard]

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

 

[Frank Kabel]

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

 

[Tom Ogilvy]

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

at Chip Pearson's site for information on Events.