View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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