Now, a security warning message is displayed at the top of the sheet table first time when you open this file, please click Enable Content button to activate the VBA code, see screenshot:ĥ. Then close the code window, and save this workbook as Excel Macro-Enabled Workbook format, please click File > Save As, and in the Save As window, select Excel Macro-Enabled Workbook from Save as type list, see screenshot:Ĥ. VBA code: Create a pop up message box when opening Excel file: Private Sub Workbook_Open()ģ.
Note: If the Project-VBAProject pane is hidden, click View > Project Explorer to display it.
In the Microsoft Visual Basic for Applications window, double click ThisWorkbook from the Project-VBAProject pane, then copy and paste the below VBA code into the Module window, see screenshot: Hold Alt + F11 keys simultaneously to open the Microsoft Visual Basic for Applications window.Ģ. You can create a VBA code to make a message box popped out when you open the specific workbook, please do as follows:ġ. Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!
