I have a macro that inserts a footer on the first page only then prints. The
footer is 3.75" tall and shouldn't appear on any other pages so I can't use
the page margins. I can't use insert page break after x number of rows
because my users will be hiding rows depending on the data from an XML
source. Is there a way to insert a page break after 7 inches?

Beth,
Why not send 2 print jobs; the cover page with the footer and the rest of
the document without the footer.

NickHK

"Beth W" wrote in message
...
I have a macro that inserts a footer on the first page only then prints.
The
footer is 3.75" tall and shouldn't appear on any other pages so I can't
use
the page margins. I can't use insert page break after x number of rows
because my users will be hiding rows depending on the data from an XML
source. Is there a way to insert a page break after 7 inches?

I tried that within the macro but because the first page footer was 3.75" and
all the other pages were .25" the rows of data that would have printed within
the footer area of the first page were not printed. The only way I was able
to print it correctly was to set the bottom margin to .25" and insert a page
break. Since this is a form that end users will be working with I'm trying to
make it idiot proof.

"NickHK" wrote:

Beth,
Why not send 2 print jobs; the cover page with the footer and the rest of
the document without the footer.

NickHK

"Beth W" wrote in message
...
I have a macro that inserts a footer on the first page only then prints.
The
footer is 3.75" tall and shouldn't appear on any other pages so I can't
use
the page margins. I can't use insert page break after x number of rows
because my users will be hiding rows depending on the data from an XML
source. Is there a way to insert a page break after 7 inches?

Beth,
Personally, I have had too much trouble trying to calculate a distance (say
your 7") in Excel with consistent printing results.
You save yourself a lot of trouble by using the first page as a cover sheet
with standard info and you large footer. The data starts on page 2.
Otherwise you would loop over the rows, adding their heights until you
reached 7" and insert a page break.
Set the large footer size, text etc.
Print page 1 only.
Reset the footer the normal size.
Print the other pages.

NickHK

"Beth W" wrote in message
...
I tried that within the macro but because the first page footer was 3.75"
and
all the other pages were .25" the rows of data that would have printed
within
the footer area of the first page were not printed. The only way I was
able
to print it correctly was to set the bottom margin to .25" and insert a
page
break. Since this is a form that end users will be working with I'm trying
to
make it idiot proof.

"NickHK" wrote:

Beth,
Why not send 2 print jobs; the cover page with the footer and the rest
of
the document without the footer.

NickHK

"Beth W" wrote in message
...
I have a macro that inserts a footer on the first page only then
prints.
The
footer is 3.75" tall and shouldn't appear on any other pages so I
can't
use
the page margins. I can't use insert page break after x number of
rows
because my users will be hiding rows depending on the data from an XML
source. Is there a way to insert a page break after 7 inches?