View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
flow23
 
Posts: n/a
Default 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