Print Macros

brejohns · May 16th, 2002, 11:52 AM

I have a workbook with numerous worksheets. I have set up various print macros by recording macros to print specific sheets. However, I have noticed that the printing message on my computer seems to take a while as it counts through each page. Is there any way to speed this up, or record a more efficient macro?

Corticus · May 16th, 2002, 12:14 PM

yes!
Excel has recorded more info than you need...

if you are recording setting up your page properties as part of the macro, that will slow it down alot. Excel records every page settup setting if you go into the setup during record, not just the changes you made.
I would recommend setting the page setup correctly outside of the macro and Excel will remember the settings. Then remove the page setup lines from your macro.

all you really need to print is this:

Sub PrintSheet1()
Sheets("Sheet1").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub

[ This Message was edited by: Corticus on 2002-05-16 11:15 ]

[ This Message was edited by: Corticus on 2002-05-16 11:16 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 11:52 AM	#1
brejohns New Member Join Date: May 2002 Posts: 17	I have a workbook with numerous worksheets. I have set up various print macros by recording macros to print specific sheets. However, I have noticed that the printing message on my computer seems to take a while as it counts through each page. Is there any way to speed this up, or record a more efficient macro?

May 16th, 2002, 12:14 PM	#2
Corticus Board Regular Join Date: Apr 2002 Location: Sarasota, FL Posts: 1,539	yes! Excel has recorded more info than you need... if you are recording setting up your page properties as part of the macro, that will slow it down alot. Excel records every page settup setting if you go into the setup during record, not just the changes you made. I would recommend setting the page setup correctly outside of the macro and Excel will remember the settings. Then remove the page setup lines from your macro. all you really need to print is this: Sub PrintSheet1() Sheets("Sheet1").Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True End Sub [ This Message was edited by: Corticus on 2002-05-16 11:15 ] [ This Message was edited by: Corticus on 2002-05-16 11:16 ]