Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie - How to close GUI but not Excel
Hello,
I am building my first Excel macro/GUI. I have put a "Close" commandbutton on the GUI and want it to close the GUI but not Excel. If tried .close and .quit but neither work. How do I get the close button to close the GUI but not close Excel? All suggestions will be greatly appreciated. TIA, Bill Burke |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie - How to close GUI but not Excel
Assuming you're talking about a Userform, try:
Unload Me Bill Burke wrote: Hello, I am building my first Excel macro/GUI. I have put a "Close" commandbutton on the GUI and want it to close the GUI but not Excel. If tried .close and .quit but neither work. How do I get the close button to close the GUI but not close Excel? All suggestions will be greatly appreciated. TIA, Bill Burke |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie - How to close GUI but not Excel
or Me.Hide if you are likely to re-open the form.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Steve Garman" wrote in message ... Assuming you're talking about a Userform, try: Unload Me Bill Burke wrote: Hello, I am building my first Excel macro/GUI. I have put a "Close" commandbutton on the GUI and want it to close the GUI but not Excel. If tried .close and ..quit but neither work. How do I get the close button to close the GUI but not close Excel? All suggestions will be greatly appreciated. TIA, Bill Burke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Real Newbie newbie question | New Users to Excel | |||
why do all excel worksheets/workbooks close when I close one? | Excel Discussion (Misc queries) | |||
Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
excel - Windows close button (x) should only close active workboo. | Setting up and Configuration of Excel | |||
Newbie help...VBA w/ Excel | Excel Programming |