Newbie - How to close GUI but not Excel

  • Thread starter Thread starter Bill Burke
  • Start date Start date
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
(e-mail address removed)
 
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)
 
Back
Top