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.

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

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

--

HTH

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


"Markus Scheible" wrote in message
...
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.
.

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

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

Application.Quit

closes excel.

--
Regards,
Tom Ogilvy

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