Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
while printing multiple worksheets and stapling
I have to set the print properties in every worksheet. Is there an easier way?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
while printing multiple worksheets and stapling
Most print setup functions will be available for grouped sheets.
Right-click on a sheet tab and "select all sheets" Do your print setup on the active sheet and will be done to all sheets. NOTE: I wrote "most"............you cannot set print range or rows to repeat at top using this method. Those must be set using code. Gord Dibben MS Excel MVP On Thu, 5 Oct 2006 11:47:01 -0700, Paul Tarango <Paul wrote: I have to set the print properties in every worksheet. Is there an easier way? Gord Dibben MS Excel MVP |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
while printing multiple worksheets and stapling
Tried that already. I want to set something in the print set up to say
duplex(2 sided). Thanks, Paul "Gord Dibben" wrote: Most print setup functions will be available for grouped sheets. Right-click on a sheet tab and "select all sheets" Do your print setup on the active sheet and will be done to all sheets. NOTE: I wrote "most"............you cannot set print range or rows to repeat at top using this method. Those must be set using code. Gord Dibben MS Excel MVP On Thu, 5 Oct 2006 11:47:01 -0700, Paul Tarango <Paul wrote: I have to set the print properties in every worksheet. Is there an easier way? Gord Dibben MS Excel MVP |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
while printing multiple worksheets and stapling
Tried this already. It didn't work.
Thanks, Paul "Gord Dibben" wrote: Most print setup functions will be available for grouped sheets. Right-click on a sheet tab and "select all sheets" Do your print setup on the active sheet and will be done to all sheets. NOTE: I wrote "most"............you cannot set print range or rows to repeat at top using this method. Those must be set using code. Gord Dibben MS Excel MVP On Thu, 5 Oct 2006 11:47:01 -0700, Paul Tarango <Paul wrote: I have to set the print properties in every worksheet. Is there an easier way? Gord Dibben MS Excel MVP |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
while printing multiple worksheets and stapling
"It" didn't work means what?
Gord On Fri, 6 Oct 2006 07:09:02 -0700, Paul Tarango wrote: Tried this already. It didn't work. Thanks, Paul "Gord Dibben" wrote: Most print setup functions will be available for grouped sheets. Right-click on a sheet tab and "select all sheets" Do your print setup on the active sheet and will be done to all sheets. NOTE: I wrote "most"............you cannot set print range or rows to repeat at top using this method. Those must be set using code. Gord Dibben MS Excel MVP On Thu, 5 Oct 2006 11:47:01 -0700, Paul Tarango <Paul wrote: I have to set the print properties in every worksheet. Is there an easier way? Gord Dibben MS Excel MVP Gord Dibben MS Excel MVP |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
while printing multiple worksheets and stapling
Gord,
Thanks for your interest. I right click the sheet tab and and "select all sheets". Then I do my print set up on the active sheet. And select 2 sided (Duplex). I have three 1 page sheets. It does not duplex. If I look at the page set up properties for the other sheets, duplex is not set. If I look at the page set up properties for the seet I'm on, duplex is set. End result, no duplex. Paul "Gord Dibben" wrote: "It" didn't work means what? Gord On Fri, 6 Oct 2006 07:09:02 -0700, Paul Tarango wrote: Tried this already. It didn't work. Thanks, Paul "Gord Dibben" wrote: Most print setup functions will be available for grouped sheets. Right-click on a sheet tab and "select all sheets" Do your print setup on the active sheet and will be done to all sheets. NOTE: I wrote "most"............you cannot set print range or rows to repeat at top using this method. Those must be set using code. Gord Dibben MS Excel MVP On Thu, 5 Oct 2006 11:47:01 -0700, Paul Tarango <Paul wrote: I have to set the print properties in every worksheet. Is there an easier way? Gord Dibben MS Excel MVP Gord Dibben MS Excel MVP |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
while printing multiple worksheets and stapling
Paul
I do not have a printer capable of duplexing so cannot do any testing for you vis-a-vis duplexing with grouped sheets. Hopefully someone has a printer and can test for you. But....maybe like setting the print range on grouped sheets cannot be done, duplexing also cannot be done. Gord On Mon, 9 Oct 2006 10:57:02 -0700, Paul Tarango wrote: Gord, Thanks for your interest. I right click the sheet tab and and "select all sheets". Then I do my print set up on the active sheet. And select 2 sided (Duplex). I have three 1 page sheets. It does not duplex. If I look at the page set up properties for the other sheets, duplex is not set. If I look at the page set up properties for the seet I'm on, duplex is set. End result, no duplex. Paul "Gord Dibben" wrote: "It" didn't work means what? Gord On Fri, 6 Oct 2006 07:09:02 -0700, Paul Tarango wrote: Tried this already. It didn't work. Thanks, Paul "Gord Dibben" wrote: Most print setup functions will be available for grouped sheets. Right-click on a sheet tab and "select all sheets" Do your print setup on the active sheet and will be done to all sheets. NOTE: I wrote "most"............you cannot set print range or rows to repeat at top using this method. Those must be set using code. Gord Dibben MS Excel MVP On Thu, 5 Oct 2006 11:47:01 -0700, Paul Tarango <Paul wrote: I have to set the print properties in every worksheet. Is there an easier way? Gord Dibben MS Excel MVP Gord Dibben MS Excel MVP |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
while printing multiple worksheets and stapling
Hi Gorg,
Thanks for trying. Paul "Gord Dibben" wrote: Paul I do not have a printer capable of duplexing so cannot do any testing for you vis-a-vis duplexing with grouped sheets. Hopefully someone has a printer and can test for you. But....maybe like setting the print range on grouped sheets cannot be done, duplexing also cannot be done. Gord On Mon, 9 Oct 2006 10:57:02 -0700, Paul Tarango wrote: Gord, Thanks for your interest. I right click the sheet tab and and "select all sheets". Then I do my print set up on the active sheet. And select 2 sided (Duplex). I have three 1 page sheets. It does not duplex. If I look at the page set up properties for the other sheets, duplex is not set. If I look at the page set up properties for the seet I'm on, duplex is set. End result, no duplex. Paul "Gord Dibben" wrote: "It" didn't work means what? Gord On Fri, 6 Oct 2006 07:09:02 -0700, Paul Tarango wrote: Tried this already. It didn't work. Thanks, Paul "Gord Dibben" wrote: Most print setup functions will be available for grouped sheets. Right-click on a sheet tab and "select all sheets" Do your print setup on the active sheet and will be done to all sheets. NOTE: I wrote "most"............you cannot set print range or rows to repeat at top using this method. Those must be set using code. Gord Dibben MS Excel MVP On Thu, 5 Oct 2006 11:47:01 -0700, Paul Tarango <Paul wrote: I have to set the print properties in every worksheet. Is there an easier way? Gord Dibben MS Excel MVP Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|