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
[TABLE="width: 149"]
<colgroup><col width="199" style="width: 149pt; mso-width-source: userset; mso-width-alt: 7277;"> <tbody>[TR]
[TD="width: 199, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 149"]
<colgroup><col width="199" style="width: 149pt; mso-width-source: userset; mso-width-alt: 7277;"> <tbody>[TR]
[TD="width: 199, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]