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?
--
Thanks

To learn:
record a macro while setting one worksheet. Now encompass into a loop macro
for each ws in worksheets
ws. blah
next ws

--
Don Guillett
SalesAid Software

"jaclh2o" wrote in message
...
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?
--
Thanks

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?

Yes:

Press the Shift key, and then click on each sheet tab to group all the sheet
in to one.

Then follow these procedure to define a custom view for printing:

1. On the View menu, click Custom Views.
2. In the Views box, click the name of the view (view: A set of display and
print settings that you can name and apply to a workbook. You can create more
than one view of the same workbook without saving separate copies of the
workbook.) you want to print.
3. Click Show.
4. Click Print .

Note Microsoft Excel saves previously defined print areas (print area: One
or more ranges of cells that you designate to print when you don't want to
print the entire worksheet. If a worksheet includes a print area, only the
print area is printed.) for each sheet in the workbook with your view. If a
sheet has no defined print areas, Microsoft Excel prints the entire worksheet.

Challa Prabhu


"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?
--
Thanks

challa

Have you tested your method?

Custom Views is not available for grouped sheets.


Gord Dibben MS Excel MVP

On Sun, 29 Apr 2007 23:50:02 -0700, challa prabhu
wrote:

Yes:

Press the Shift key, and then click on each sheet tab to group all the sheet
in to one.

Then follow these procedure to define a custom view for printing:

1. On the View menu, click Custom Views.
2. In the Views box, click the name of the view (view: A set of display and
print settings that you can name and apply to a workbook. You can create more
than one view of the same workbook without saving separate copies of the
workbook.) you want to print.
3. Click Show.
4. Click Print .

Note Microsoft Excel saves previously defined print areas (print area: One
or more ranges of cells that you designate to print when you don't want to
print the entire worksheet. If a worksheet includes a print area, only the
print area is printed.) for each sheet in the workbook with your view. If a
sheet has no defined print areas, Microsoft Excel prints the entire worksheet.

Challa Prabhu


"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?
--
Thanks

Thanks Gord Dibben. I appolige. Normally I check before sending the reply to
any post. I will check again.

Challa Prabhu

"Gord Dibben" wrote:

challa

Have you tested your method?

Custom Views is not available for grouped sheets.


Gord Dibben MS Excel MVP

On Sun, 29 Apr 2007 23:50:02 -0700, challa prabhu
wrote:

Yes:

Press the Shift key, and then click on each sheet tab to group all the sheet
in to one.

Then follow these procedure to define a custom view for printing:

1. On the View menu, click Custom Views.
2. In the Views box, click the name of the view (view: A set of display and
print settings that you can name and apply to a workbook. You can create more
than one view of the same workbook without saving separate copies of the
workbook.) you want to print.
3. Click Show.
4. Click Print .

Note Microsoft Excel saves previously defined print areas (print area: One
or more ranges of cells that you designate to print when you don't want to
print the entire worksheet. If a worksheet includes a print area, only the
print area is printed.) for each sheet in the workbook with your view. If a
sheet has no defined print areas, Microsoft Excel prints the entire worksheet.

Challa Prabhu


"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?
--
Thanks