Liam has attended:
Excel VBA Intermediate course
Excel VBA Intermediate course
Excel VBA Intermediate course
Run VBA code when new workbook is created
Is there anyway to run VBA code (a subroutine) when a new workbook is created?
RE: Run VBA code when new workbook is created
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