[SOLVED] How do I put a button on an excel spreadsheet to print a report?

[Casper]

Hi please help
I want to put a button onto a excel spreadsheet (not the toolbar) that will
print a report for me from another sheet, what macro do I use and what
options do I use
Regards
Casper

[keithl816]

Hi Casper,

Try going to design mode in your toolbar and clicking on the command button icon place it on the sheet desired then right click the button, click view code and try placing the code below.

I set this up as sheet 2 being the one printed, change as needed. The same will go for the print range.

Please Login or Register  to view this content.

Hope this helps

[Dave Peterson]

I would record a macro when I printed what I wanted.

Then I'd use a button from the Forms toolbar and plop it onto that other
sheet--and assign that recorded macro to that button.

Your recorded macro may look something like:

Option Explicit
Sub Macro1()
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub

I'd change it to be more specific (and give it a nice name):

Option Explicit
Sub PrintSheet1()
worksheets("sheet1").PrintOut Copies:=1, Collate:=True
End Sub

Casper wrote:
>
> Hi please help
> I want to put a button onto a excel spreadsheet (not the toolbar) that will
> print a report for me from another sheet, what macro do I use and what
> options do I use
> Regards
> Casper

--

Dave Peterson