Put this in the ThisWorkbook code module (with Test1 in a regular code
module):

Private Sub Workbook_Open()
Test1
End Sub


In article ,
"JT" wrote:

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...