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
 
Back
Top