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

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

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