Private Sub Workbook_Open()
'YOUR CODE
End Sub

put this in the "ThisWorkbook" module

"JT" wrote in message
...
I have a public sub call "Test1". I want to make this
macro run when the workbook is open but I'm not sure how
to use the workbook open event. Any help would be greatly
appreciated. Thanks...