I am no genius with VB, however I was quite happy with myself when I created a workbook and added under Workbook_Open() four sub-routine's by simply using Call Macro1(), Cal Macro2(), etc.
However in my current project file under Workbook_Open(), I start with:
Private Sub Workbook_Open
Dim Evnt As String
Evnt="Open"
Call Log1(Evnt)
Call LittleDotClick()
End Sub
However upon successful completion of Log1(Evnt), the code does not return to then run LittleDotClick()
Hence I would appreciate any guidance, as there are several other sub-routines I wish to add.
Many thanks
<colgroup><col width="199" style="width: 149pt; mso-width-source: userset; mso-width-alt: 7277;">
<tbody>
</tbody>
However in my current project file under Workbook_Open(), I start with:
Private Sub Workbook_Open
Dim Evnt As String
Evnt="Open"
Call Log1(Evnt)
Call LittleDotClick()
End Sub
However upon successful completion of Log1(Evnt), the code does not return to then run LittleDotClick()
Hence I would appreciate any guidance, as there are several other sub-routines I wish to add.
Many thanks