Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook Open code
Neal,
Open the ThisWorkbook code module, and enter the code Private Sub Workbook_Open() ' your code here End Sub This event procedure will execute when the workbook is opened. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Neal" wrote in message ... Dear experts, I am using Excel 97. When the user opens the workbook, I would like to have a message box appear and also clear out some cells from a previous user. I already have the code for the macro, but how do I have this happen when the workbook is opened? Thanks in advance. Neal |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ON OPEN VBA Code input incorrectly now excel sheet wont open | New Users to Excel | |||
how can i open a second workbook using a vba code | Excel Discussion (Misc queries) | |||
How to code VBA: Auto open workbook and run macro | Excel Discussion (Misc queries) | |||
Need VB code for workbook open to open a link | Excel Discussion (Misc queries) | |||
Need VBA Code to Open a Workbook in read only | Excel Discussion (Misc queries) |