View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default VBA Form Button Closing WorkSheet

application.quit

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bill Brutzman" wrote in message
...

This helps to close the worksheet...how about closing down Excel
altogether...like another red "X" button.

"Markus Scheible" wrote:

Hi Bill.

Simply insert a button and write a macro containing the
following:

sub btnclck()
workbooks("abcd.xls").close
unload me
end sub


Best

Markus



-----Original Message-----
Aside from the red "X" in the upper right corner, my boss

wants a button on a
form that would close out of the worksheet (and the

macro) altogether.
.