Newbie - How to close GUI but not Excel

B

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
[email protected]
 
B

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)
 
Top