G glensnow New Member Joined Oct 29, 2005 Messages 16 Nov 27, 2005 #1 I am new to VB and an looking to have a macro automatically execute when the file is opened. Can someone help?? Thanks Glen
I am new to VB and an looking to have a macro automatically execute when the file is opened. Can someone help?? Thanks Glen
A anthonya2369 Active Member Joined Mar 10, 2005 Messages 321 Nov 27, 2005 #2 Under the ThisWorkbook item, you can. Code: Private Sub Workbook_Open() MsgBox "test" End Sub This would pop up Test message box everytime the workbook was open.
Under the ThisWorkbook item, you can. Code: Private Sub Workbook_Open() MsgBox "test" End Sub This would pop up Test message box everytime the workbook was open.
G glensnow New Member Joined Oct 29, 2005 Messages 16 Nov 28, 2005 #3 Thanks Anthony. Your recommendation worked perfectly. Cheers!! Glen