Thread: Set print area for entire workbook
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Set print area for entire workbook
Using VBA code you can set the same print range and rows to repeat at top on
each sheet in grouped sheets.

For anyone interested in the code see this google search result with Dave
Peterson and myself posting. The print area code is from Bob Flanagan.

http://snipurl.com/106kz


Gord Dibben MS Excel MVP

On Fri, 15 Jun 2007 11:54:02 -0700, Flambeau
wrote:

How can I set the print area to be the same for all the pages of a workbook
at one time?

I am using MS Office Excel 2007

Thanks for any help!

Reply With QuoteReply With Quote