![]() Notice that, in default, the Open will be displayed in right drop down list, if not, change it to Open.ģ. In the code window, select Workbook from the left drop down list. ![]() Double click ThisWorkbook in Project – VBAProject pane to open the ThisWorkbook (Code) window.Ģ. Enable the workbook, press Alt + F11 keys to open the Microsoft Visual Basic for Applications window.Ģ. In this article, I will tell you how to run the VBA code while opening or closing the workbook every time.ġ. But have you ever tried to run the VBA macro in each time of opening or closing the workbook. In many cases we may use the VBA code to achieve the operations which Excel built-in functions not support. ![]() How to run VBA macro when open or close workbook?
0 Comments
Leave a Reply. |