Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing Two pages per sheet
I have a workbook with 2 worksheets, "Summary" and "Result" I have in a macro a command to print each worksheet. I want to prin "Summary" normally, but I would like to print "Result" as 2 pages to sheet. At present I have "solved" the problem by replacing the comman line to Print "Result" with a PrintPreview command. Then I manuall print and in the printer dialog box change the properties to printing pages per sheet. My question is: can I do this automatically in code so that I don' have to manually change to "2 pages per sheet" every time I Prin "Result"? Thanks for any help Fre -- freekril ----------------------------------------------------------------------- freekrill's Profile: http://www.excelforum.com/member.php...nfo&userid=756 View this thread: http://www.excelforum.com/showthread.php?threadid=52550 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ADD PRINTING WATERMARK ON FEW PAGES OF A SHEET | New Users to Excel | |||
Printing multiple pages on one sheet | Excel Discussion (Misc queries) | |||
printing multi pages on one sheet | Setting up and Configuration of Excel | |||
Printing a sheet onto 4 pages: page 2 is empty. | Excel Discussion (Misc queries) | |||
Programmatically printing x pages/sheet | Excel Programming |