Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Automatically Run Macro When Opening. How to run a Macro upon opening a workbook Press AltF11 to open the VB Editor or go to tab Developer on the ribbon click on Visual Basic button. This is the easier of the two circumstances.
Now click the ThisWorkbook module. Open the Visual Basic Editor by pushing ALT F11. Specifically you can add macros to a template that run when you create a new document or open and close an existing document based on the template.
The syntax of this event is this.
This first method does have limitations which will be covered in its explanation below. Then go to the Properties window. To get this project to be automatically loaded and run when you start MicroStation perform the following. Enter the code below into the code window.