Change Header or footer using input box

[hecgroups]

Hello,

I have about 9 sheets which i use daily for different clients (Contract). Every time i have to change header and footer.

Header contain company name and footer contain file no.

Can anyone one help me in this regards.

What i want is VBA macros asking for enter header text and after that ask me to add footer text.

Can anyone do this for me please.

[Domski]

Something like this maybe:

Please Login or Register  to view this content.

Dom

[hecgroups]

Excellent boss thanks for sharing your script with me.

[rockymtngirl]

What if you only want an input prompt for the subject of a three line center header such as in:

(Prompt for subject)
For Month Ended
November 30, 2016

My macro header is used for many workbooks, so the only thing that is consistent is the "For Month Ended" and the date scripts. Although I do have to go in to the code and change the date when a new month has arrived, I know of no other way to do this since I wouldn't want to have to type it in at each input prompt either.

Can an input prompt just be given for the first line of a three line center header? How would you put in the rest of the script so that you're not having to "input" it each time too?

Thanks!

[FDibbins]

rockymtngirl welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.