View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris G Chris G is offline
external usenet poster
 
Posts: 5
Default Forms - how do you get them to disappear?

Hi,
Forms - how do you get them to disappear when
a) you click the cancel button
and
b) when you click the OK and the assigned macro has finished running

Please see the code attached for what I've tried already. "Printform" is the
name of the form. I've remmed out the lines that didn't work

'Private Sub Cancel_Click()
'Printform.Hide - didn't work
'Printform.Enabled = False - didn't work
'End Sub

Private Sub OK_Click()
If Printall.Value = True Then
Call PrintAllSheets
Exit Sub
Else
If print1.Value = True Then Call Printarea1
End If
'Printform.Hide - didn't work
End Sub