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

Frank

Nigel Chapman wrote:
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(a35,runmacro,0) ?????

Thanks

Nigel