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 |
All times are GMT +1. The time now is 06:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com