View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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