Automatically Open the VBA IDE Whenever a Project Is Loaded

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.