Excel VBA

How to run Excel macro on file opening

Here is how to run Excel macro automatically every time you open the file in a few easy steps.

1. When you are in Excel file press Alt + F11 to open VBA window.

2. In the Project section, locate your file and open ThisWorkbook section.

3. You should make subroutine with Workbook_Open event that contains the name of your macro.

The result looks like this.

If you want to close your workbook automatically when the macro is executed, I recommend adding these lines at the end of the subroutine.

How to open an Excel file that contains macro (that runs automatically on file opening) without running it.

 

Go to File -> Open (Ctrl + O) and browse to your file.

Open in while holding the Shift key. That will prevent to run a macro automatically.



0 comments on “How to run Excel macro on file opening

Leave a Reply

Your email address will not be published. Required fields are marked *