I am trying to launch a userform when the workbook is opened. Following the VBA help files, I created a new class module with the "Public WithEvents App As Application" declaration. Then here is my code:
Private Sub App_WorkbookOpen(ByVal Wb As Workbook)
If Worksheets(Main).Range(C5).Value = 0 Then UserForm1.Show
End Sub
I may be way off base and not doing it right at all.. thanks in advance
Private Sub App_WorkbookOpen(ByVal Wb As Workbook)
If Worksheets(Main).Range(C5).Value = 0 Then UserForm1.Show
End Sub
I may be way off base and not doing it right at all.. thanks in advance