How do I create a print button?
 

I am creating a spreadsheet for some unsophisticated users and would like to
have them select a range and then just click on a "print" button. I assume I
need to create a macro and embed it in the button. Could use some help with
that, as well.

Thanks!

Add this code to the button click event

Selection.Printout

this will print the currently selected cells on the active sheet.





"Dan" wrote in message
...
I am creating a spreadsheet for some unsophisticated users and would like
to
have them select a range and then just click on a "print" button. I
assume I
need to create a macro and embed it in the button. Could use some help
with
that, as well.

Thanks!

unsophisticated creators would do that

sub printit
range("a2:b22").printout
end sub

--
Don Guillett
SalesAid Software

"Dan" wrote in message
...
I am creating a spreadsheet for some unsophisticated users and would like
to
have them select a range and then just click on a "print" button. I
assume I
need to create a macro and embed it in the button. Could use some help
with
that, as well.

Thanks!

unsophisticated responders such as me should have said what Nick said.

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
unsophisticated creators would do that

sub printit
range("a2:b22").printout
end sub

--
Don Guillett
SalesAid Software

"Dan" wrote in message
...
I am creating a spreadsheet for some unsophisticated users and would
like
to
have them select a range and then just click on a "print" button. I
assume I
need to create a macro and embed it in the button. Could use some help
with
that, as well.

Thanks!