View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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