workbook footer

ercstric · Feb 28th, 2002, 10:04 PM

say i have a workbook with 30 sheets, i want the same footer for every sheet. but the footer may change everyweek, is there a way to set up a "master footer" so i don't have to edit each sheet's footer, but rather just one, and it updates all the other sheets?

thanks,
eric

Ivan F Moala · Feb 28th, 2002, 10:49 PM

You can select ALL your sheets by selecting the 1st then holding shift and selecting the last (or what ever) THEN File Page setup
and set your footer etc.

If you want a custom footer then you can do this via code.....post your requirements

Ivan

ercstric · Mar 1st, 2002, 04:30 AM

thanks IVAN

worked like a charm

eric

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 28th, 2002, 10:04 PM	#1
ercstric New Member Join Date: Feb 2002 Posts: 16	say i have a workbook with 30 sheets, i want the same footer for every sheet. but the footer may change everyweek, is there a way to set up a "master footer" so i don't have to edit each sheet's footer, but rather just one, and it updates all the other sheets? thanks, eric

Feb 28th, 2002, 10:49 PM	#2
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	You can select ALL your sheets by selecting the 1st then holding shift and selecting the last (or what ever) THEN File Page setup and set your footer etc. If you want a custom footer then you can do this via code.....post your requirements Ivan

Mar 1st, 2002, 04:30 AM	#3
ercstric New Member Join Date: Feb 2002 Posts: 16	thanks IVAN worked like a charm eric