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

Forms - how do you get them to disappear?
 

try unload printform


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=487208