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