itipu
07-26-2007, 05:46 AM
Hi All!!!
I have something like this:
Sub Mike()
'creates worksheet A
End Sub
Sub John()
'creates worksheet B
End Sub
Sub Mark()
'created worksheet C
End Sub
I also have:
'Maint Report:
Private Sub CommandButton1_Click()
Mike
John
Mark
UserForm1.Show
End Sub
UserForm1 will ask user to select sheets and will perform some operations on the sheets...
However script jumps to UserForm1.Show right after it generates worksheet A or calls proceedure Mike...
Why does it not call on John and Mark?
I can manually generate all worksheets, so I can manually run Mike, John & Mark and they all work!
Thanks a lot
Mike
I have something like this:
Sub Mike()
'creates worksheet A
End Sub
Sub John()
'creates worksheet B
End Sub
Sub Mark()
'created worksheet C
End Sub
I also have:
'Maint Report:
Private Sub CommandButton1_Click()
Mike
John
Mark
UserForm1.Show
End Sub
UserForm1 will ask user to select sheets and will perform some operations on the sheets...
However script jumps to UserForm1.Show right after it generates worksheet A or calls proceedure Mike...
Why does it not call on John and Mark?
I can manually generate all worksheets, so I can manually run Mike, John & Mark and they all work!
Thanks a lot
Mike