Run VBA code when new workbook is created | Excel forum

Hi Liam,

Thank you for the forum question.

Do you mean that you want Excel to execute a macro triggered by a new workbook event?

Do you want Excel to automatically execute a macro every time you create a new workbook.

You can execute your macros in all your files also in a new created file. If the macro is stored in another file, you just have to have the file open to execute the macro in the new created file.

You can also store the macro in your Excel personal template. Then the code can be executed in all files without having at specific file open.

If you want to automatically execute the macro, you will need to define an workbook event to trigger the macro.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector