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" <[email protected]> wrote in message
news:[email protected]...
>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
[email protected]
"Dan" <[email protected]> wrote in message
news:[email protected]...
> 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
[email protected]
"Don Guillett" <[email protected]> wrote in message
news:%[email protected]...
> unsophisticated creators would do that
>
> sub printit
> range("a2:b22").printout
> end sub
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "Dan" <[email protected]> wrote in message
> news:[email protected]...
> > 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!
>
>