Print Ranges and rows to repeat at top cannot be set on grouped sheets without
using VBA.

See this google thread for code.

http://snipurl.com/106kz


Gord Dibben MS Excel MVP

On Fri, 27 Apr 2007 12:18:01 -0700, jaclh2o
wrote:

I have a workbook with 12 worksheets (12 months) and need to have about 10
specific print areas within a worksheet that are the same for the whole
workbook. Is there a way of defining it without creating areas one worksheet
at the time? Can one standard area be defined in one worksheet and be applied
automatically in the whole workbook?