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

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

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