How do I do Auto_Activate Macro?

  • Thread starter Thread starter Bernhard
  • Start date Start date
B

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
 
Hi Bernhard
use either the workbook_open event (in your workbook module) or name
your macro Auto_Open()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Start Macro in Excel 2
Personal Macro Workbook 2
a macro that runs automatically when a workbook is opened 2
comandbar controls 5
Macro with stop date 1
Excel 2007 macro assigned to button 3
Need VBA Code 6
Addin not allowing thisworkbook.save in before save event 3

Back
Top