ExcelBanter - Autorun a macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Autorun a macro (https://www.excelbanter.com/excel-programming/290208-autorun-macro.html)

Nigel Chapman

Autorun a macro

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

Frank Kabel

Autorun a macro

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

All times are GMT +1. The time now is 01:21 AM.