Building a Header Macro

J

Jonathan

Can anyone help me with a header macro? I would like to combine the macro
suggested in subject : "Prompt user for Customer Name to use info in Header"
with a standard macro for dropping in the below header/footer settings:

LeftFooter - Prepared by: My Name, Time/Date
CenterFooter - Filepath
RightFooter - Page of Pages
CenterHeader - Company Name

Ideally I would like to set the prompt for the CenterHeader (the originally
suggested macro was set for CenterFooter), but can this be done if I also
want to see my Company name above the prompted text? Example:

Good Works Company
<prompted text>

Thanks!
JB
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add standard header and footer to new worksheet 2
Formula in Header 2
Another .PageSetup Thread (xl2010) 6
Word macro that can call cells out of Excel for a find and replace 0
To get the same header,footer and sheet titles across multiple sheetsof a workbook. 1
Macro help: File path in Excel 2000 2
Header and Footer Macro 1
Code for formatting header 4

Top