Morris,

In the ThisWorkbook code module, put in

Private Sub ThisWorkbook_Open()
' your code here
End Sub

Alternately, you can name the macro, in a standard code module, Auto_Open.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Morris Benjamin" wrote in message
...
How do you setup a macro to start running when the
workbook is opened? Thank you in advance for the
assistance.

Morris