Autorun a macro

  • Thread starter Thread starter Nigel Chapman
  • Start date Start date
N

Nigel Chapman

Can anyone help me please :

I want to run a macro automatically as soon as I open an Excel workbook. Is
this possible?
Failing that is it possible to run a macro from with an IF statement -
If(a3>5,runmacro,0) ?????

Thanks

Nigel
 
Hi nigel
two ways:
1. Name your macro Auto_Open
2. place your code in the workbook_open event of your workbook module

Frank
 

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

Run Macro If Cell have "x" value 0
Macro for Creating Word Document!! 5
Removing Command Button 31
How do I run a macro from a .xlt file 3
Altered pasting functionality 3
How to Unlock Excel Workbook protected by MACRO Password 6
Access Macro Repeat Expression using value of a field in table 0
Call Excel Macro from Outlook 2

Back
Top