VBA Form Button Closing WorkSheet

[Bill Brutzman]

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.

 

[Markus Scheible]

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

 

[Bob Phillips]

Don't need the unload me, there is no form to unload.

--

HTH

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

 

[Bill Brutzman]

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

 

[Bob Phillips]

application.quit

--

HTH

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

 

[Tom Ogilvy]

Application.Quit

closes excel.