How To Auto-Run Macro When Excel File Is Opened

In this tutorial we look at how you can schedule a macro/ VBA Script to run every-time a file is opened.

It is easier than you think to implement this functionality and utilises functionality already available to us within Microsoft Excel.

If you have any questions about this video, please leave a comment and I will respond soon as possible 🙂

#excel #vba #autorun #msexcel #macros #openworkbook

[EssentialExcel]

I hope you enjoyed this tutorial 😃 If you did please give it a LIKE... and don’t forget to SUBSCRIBE for even more content!

[setsunarehaf]

can i run a a code containing the last modified date of the sheet once the sheet is open? if yes how?

[samkab]

If option macros are disabled what the use of making macros then?

[imyong]

I try it but keep on getting the error "Sub or Function not defined"

[ZegnaAlfieri]

are you recording this with a calculator? i can't se anything

[drontek]

How do you run more than one macro automatically when document is opened? I have a number of tasks I want to run whenever its opened

[DevPoint.]

This method can be used for injecting malicious software 😄