Paul,

Two ways.......
One...
Create a sub in a regular module named Auto_Open
e.g.
Sub Auto_Open()
' your code here or call another sub
End Sub

or in the Workbook_Open Event
Double Click on "ThisWorkbook" in the "Projects" Window
Copy and paste the following

Private Sub Workbook_Open()
' your code here or call another sub
End Sub

John

Paul Scott wrote:

Is there a way to program an Excel file to run a macro
when the file opens?