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



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

On Mon, 2 Feb 2009 14:13:00 -0800, scru_ball
<scru_ball@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

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?

.



Relevant Pages

  • RE: Excel is now printing all the entire workbook.
    ... You can define a print area that will print only the print area unless a ... remove any template files from the XLStart folder. ... opened the print dialog box and reset the button to active sheet. ... Workbook' and I am unable to save the change. ...
    (microsoft.public.excel.misc)
  • Re: Merge Word 2000
    ... I would forget about the "Print Area" thing as it doesn't really have any ... The thing to do is select the header row and data you want (in Excel), ... to the appropriate sheet, ready for the next mail merge. ... Joiners ". ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Cant We Set Print Area with condition?
    ... If you have a header row, you'll want to adjust that countifportion: ... I would like to set auto print area to an worksheet. ... If excel auto selects the print area, ... I have 2 sheets, on the first sheet I do the calculations. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Multiple print areas
    ... "ActiveSheet.PrintOut 'Prints the Print area" ... Another option is to create a new sheet, set print area (I've left this ... print from there & then delete the temp sheet using code ...
    (microsoft.public.excel.programming)
  • Re: Cant We Set Print Area with condition?
    ... If you have a header row, you'll want to adjust that countifportion: ... I would like to set auto print area to an worksheet. ... If excel auto selects the print area, ... I have 2 sheets, on the first sheet I do the calculations. ...
    (microsoft.public.excel.worksheet.functions)