Page set up across multiple files ? x

Hi everyone, i have another question, but have made progress on the others so thanks everyone.

I have a number of worksheets on a file, what I would like to do, for each of them is:
Set them with a print setup to print in landscape with row 13 printed at the top of each page (if across multiple pages) and with a Page number on the bottom.
Thanks for any help
Amy xx

Record a macro while you make those setting manual.

Look at the recorded code and delete any default settings that you don't
need.

Now you can

loop through you list of sheets, activate the sheet and execute the
(modified) recorded code.

--
Regards,
Tom Ogilvy


"AmyTaylor" wrote:

>
> Hi everyone, i have another question, but have made progress on the
> others so thanks everyone.
>
> I have a number of worksheets on a file, what I would like to do, for
> each of them is:
> Set them with a print setup to print in landscape with row 13 printed
> at the top of each page (if across multiple pages) and with a Page
> number on the bottom.
> Thanks for any help
> Amy xx
>
>
> --
> AmyTaylor
> ------------------------------------------------------------------------
> AmyTaylor's Profile: http://www.excelforum.com/member.php...o&userid=20970
> View this thread: http://www.excelforum.com/showthread...hreadid=539244
>
>