Excel Workbook automatically (by design) runs a macro
Paul,
You can name the macro to be run Auto_Open, or you can use the Workbook_Open event procedure in the ThisWorkbook code module: Private Sub Workbook_Open() ' your code here End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Paul" wrote in message ... How do I set an Excel Workbook to run a macro when the workbook is open? Thx Paul |
All times are GMT +1. The time now is 07:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com