Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Form does not disappear | Excel Programming | |||
Add-Ins disappear | Setting up and Configuration of Excel | |||
RefEdits and normal forms / forms in a DLL | Excel Programming | |||
Forms that open from forms | Excel Programming | |||
Calling Forms from Forms - Exit problems | Excel Programming |