Macro for file path and worksheet in footer with font size

COlivianus · May 13th, 2002, 11:06 AM

Hello,

I've seen the macro to place the file and worksheet name in the footer, and macros to place text of a certain font size into the footer. However, I need a macro that places the file and worksheet name at 8 pt font into the footer.

Thanks.

Nimrod · May 13th, 2002, 11:16 AM

This all can be done through page setup.
-File
--page setup
---Header/Footer Tab
----Custom footer
-----Select area of footer you want data in
------Click on the right 2 icons to insert File and Tab name variables

Rocky E · May 13th, 2002, 12:05 PM

Hi,
Nimrod left off a step. On the Custom Header/Footer page is a lagre A for font control. Either set it first or highlight your selection to set to 8pt.

Turn on the Marco Recorder for the VBA code before you do these steps and you will a a macro.

_________________
Hope this helps!

Rocky

"Be not the first by whom the New are try'd,
Nor yet the last to lay the Old aside."
Alexander Pope (1688-1744).

[ This Message was edited by: Rocky E on 2002-05-13 11:07 ]

[ This Message was edited by: Rocky E on 2002-05-13 11:10 ]

May 13th, 2002, 11:16 AM	#2
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	This all can be done through page setup. -File --page setup ---Header/Footer Tab ----Custom footer -----Select area of footer you want data in ------Click on the right 2 icons to insert File and Tab name variables __________________ <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

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

May 13th, 2002, 11:06 AM	#1
COlivianus New Member Join Date: May 2002 Posts: 3	Hello, I've seen the macro to place the file and worksheet name in the footer, and macros to place text of a certain font size into the footer. However, I need a macro that places the file and worksheet name at 8 pt font into the footer. Thanks.

May 13th, 2002, 12:05 PM	#3
Rocky E Board Regular Join Date: Feb 2002 Location: North Alabama, USA Posts: 105	Hi, Nimrod left off a step. On the Custom Header/Footer page is a lagre A for font control. Either set it first or highlight your selection to set to 8pt. Turn on the Marco Recorder for the VBA code before you do these steps and you will a a macro. _________________ Hope this helps! Rocky "Be not the first by whom the New are try'd, Nor yet the last to lay the Old aside." Alexander Pope (1688-1744). [ This Message was edited by: Rocky E on 2002-05-13 11:07 ] [ This Message was edited by: Rocky E on 2002-05-13 11:10 ]