Automatically Run a VBA Macro
Develop Applications with VBA
Work in a Zero Document State
There is an option on the Open VBA Project dialog box that allows you to open the interactive development environment automatically. Simply select the Open Visual Basic Editor check box found in the lower-left side of the dialog box and the VBA IDE will open automatically whenever a VBA project is loaded. This option will remain set until you turn it off again.
NoteTo access the Open VBA
Project dialog box, enter VBALOAD at the command line. The dialog
box will open and allow you to choose a project to load. If you
do not see the Open VBA Project dialog box, it is most likely because
the system variable FILEDIA is turned off. This system variable
turns on and off the display of dialog boxes. To turn FILEDIA back
on, set it to 1.