Thursday, 8 August 2013

How to call sub routine from initiating event in VBA

How to call sub routine from initiating event in VBA

I have within the same VBA project
Private Sub Workbook_Open()
(...)
End Sub
contained inside Microsoft Excel Objects>>"ThisWorkbook", and
Public Sub Method (arg As String)
(...)
End Sub
contained inside Modules>>Module2. How can I run "Method" when initiatin
my Workbook?
e.g
Private Sub Workbook_Open()
Method "abcd"
End Sub

No comments:

Post a Comment