How to create a print button.

[pt109]

When I send my spreadsheets to my clients I would like to
create a graphical button, so when they click on the
button it will print specific sheets in landscape.

Any suggestions are welcome.

Thanks
Pheroz

 

[Paul B]

Pheroz, how about something like this

Sub Set_and_print_page()
With Sheet1.PageSetup
.Orientation = xlLandscape
End With
Sheets("Sheet1").PrintOut
End Sub


--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Gary]

Easy. First choose Tools then Macro's and record a new
macro. While the macro is recording, open the selected
sheets and then print them. Stop recording the macro.

Then, using the Excel toolbox, paste a new button onto
your workbook. Right click on it, choose assign macro
and choose the macro which is to run - ie the one you
just created.

When people press the button, it will run the macro and
print the selected sheets.