Macro to create a custom header/footer...

J

jgbadingerjr

Looking for a macro to enter a custom header and a footer

Header would have:

title of worksheet
job#
client name
date


footer would have:

file path
author
page# of total pages

I saw how to create file paths and dates but I'm trying to combo everything
into an easy to enter series of text boxes so our personnel don't have to
open page setup each time...
any suggestions would be appreciated
Thanks
 
Top