userform freezes
first time creating a user form.
BAsically 3 buttons to execute macros.
Private Sub CommandButton1_Click()
data
form.hide
End Sub
Private Sub CommandButton2_Click()
Print1
form.hide
End Sub
Private Sub CommandButton3_Click()
ActiveWorkbook.Close
form.hide
End Sub
Private Sub CommandButton4_Click()
Print2
fom.hide
End Sub
however when I click the first buttion.. it doesnt execute the macro.
2nd and 3rd button are ok.
but it freezes
and exit is perfect
|