Form Actions
Hi,
I have 2 forms on the first form is a button which saves the current work
book, unloads the form and then opens the second form. The problem is when I
click the first button the form does not shut and the second one opens over
the top and when you click the button on the second form to shut it the whole
thing crash's can someone help, here is code I am using
Button One
Private Sub Finnish_Click()
ActiveWorkbook.Save
ActiveWorkbook.SaveAs Filename:="C:\Questionaire.xls"
Unload Me
UserForm3.Show
End Sub
Button Two
Private Sub UserForm_Click()
Unload Me
End Sub
Thanks
|