Run PERSONAL.XLSB macro when any Excel file is opened

[Aaron092]

Hi all

Hoping this is pretty simple and I'm just being an idiot.
I need to store a macro in PERSONAL.XLSB but I need it to run when any excel file is opened (as it checks what the file contains, then does a lot of work for me.)

I've seen other people have done this, but I can't get it to work for some reason. Any help is appreciated!

Thank you

Aaron

[romperstomper]

In the ThisWorkbook module of your Personal.xlsb, put this code, changing the blue part to match your macro name:

Please Login or Register  to view this content.

Then save the workbook and restart Excel.

[Aaron092]

Hi romperstomper

That works perfectly!! Exactly what I needed - thank you

[romperstomper]

Glad to help.