Newbie - How to close GUI but not Excel

[Bill Burke]

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
(e-mail address removed)

 

[Steve Garman]

Assuming you're talking about a Userform, try:

Unload Me

 

[Bob Phillips]

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)