Putting a macro in an add-in which will auto run each time a

[philR]

Hi peeps,
does anyone know a way to save a macro in an add-in which will run automatically whenever the user opens a new file?

 

[XL-Dennis]

philR,

What exactly are You trying to achieve?

Kind regards,
Dennis

 

[Juan Pablo González]

Two choices right now:

- Put the macro in the Personal.xls file.

- Save the AddIn in the XLSTART folder.

Also, make sure that the macro is called from the Workbook_Open() event.