Auto execute macro setup

[glensnow]

I am new to VB and an looking to have a macro automatically execute when the file is opened. Can someone help??

Thanks
Glen

 

[anthonya2369]

Under the ThisWorkbook item, you can.

Private Sub Workbook_Open()
    MsgBox "test"
End Sub

This would pop up Test message box everytime the workbook was open.

 

[glensnow]

Thanks Anthony. Your recommendation worked perfectly.


Cheers!!
Glen