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.
.
|