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
|