Footer page number scaling

[Peter Horncastle]

Hi there, dont think there is a solution to this damn annoying problem
I have, but you never know!

When you create a footer to list the pages in a work book, they seem
to be linked to the scaling of the print set up, so if I have a work
book of 10 pages and 5 of them are say 100% and the other 5 are at 50%
to fit to page the footer then becomes tiny on these pages and is not
obviously consistent with the other pages when printed out and put
together as a folder.

Is there any way around this? I have tried using report manager
add-in which from the looks of things is pretty much useless.

I will need to create a pack that includes about 200 worksheets from
about 10 workbooks so formatting them individually will be a problem,
or exporting them to say powerpoint will also be a nightmare.

Is there any solution in Excel or any other method like a seperate
program that can get around this frustrating problem?

Thanks very much

Peter

 

[Dave Peterson]

If your final output is paper, maybe you could print the footers the way you
want, then send the paper through the printer a second time for the real data.

(Maybe use MSWord for the inital footer.)

Not a very good way, huh?