How do I set a print area for every sheet in the workbook?

S

scru_ball

When I print from an Excel workbook, I want to print the same print are for
every sheet. Is there a way to make it the default print area without having
to select it in every sheet?
 
G

Gord Dibben

Unfortunately print area and rows to repeat are two functions that cannot be
set with grouped sheets as Bob I suggested.

Using VBA code you can set the same print range and rows to repeat at top on
each sheet in grouped sheets.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting print area for entire workbook 1
Print Area to include text box 10
how to set print area for the entire excel workbook 1
setting page setup/print area for multiple sheets 6
Need to print a workbook but worksheets have diff print areas 1
Conditional Print Area 11
How do I set global in print titles? 3
Printing Different Sections of same Sheet 1

Top