Footer: multi-line how-to

[m3site]

I have never done VBA or macros. Can someone walk me thru the how-to of creating a multi-line custom footer?

I want every page to show the company name, logo, address, etc in the footer and this requires 2 full lines


I'm using Excel 2000


many thanks

[shg]

Try recording a macro (Tools > Macro, Record New Macro), then look at the code it generates.

[m3site]

thank you but did you see that I have never done a macro ... I don't know what you mean by a code

[shg]

That's why using the macro recorder is a good place to start -- it's where we all started.

After you record the macro, you can do Alt+F8 and select it from the list to run again.

Or you can do Alt+F11 to open the Visual Basic Editor, and in the Project window, open Module1 to see the code that you recorded.

[Andy Pope]

If your logo is an image you will have a problem. xl2000 does not support images in footer.

Do you have to do this with code?

Do you know who to do it manually? If so just turn on the macro recorder and then perform the manual tasks.

Doing so will produce relevant code

Please Login or Register  to view this content.

The Chr(10) causes the new line