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