Page set up => header/footer => custom footer => repeat for all pages and sheets

[GerB]

Is there a way to output the same custom footer (e.g. client name + project name) on each page printed out from all the sheets in a workbook.....other than
1 Using fixed print rows
2 Manually setting up for each sheet or
3 Creating a new page insert template?

[Alf]

Perhaps record a macro setting up the custom footer in one workbook and then let the macro loop through all sheets in the workbook.

Alf

[GerB]

Thanks Alf.
I'm ok with recording the macro......the bit that I have a problem with is getting a loop to work going through all sheets in the workbook! Would have you have an example of the VBA code for this?
Thanks.
Ger

[Alf]

Hi Ger,

You could try something like this:

Please Login or Register  to view this content.

Alf

[GerB]

Thanks a million Alf....it took a few attempts to get it to run....but it's running perfectly now!
So this = solved!
Ger

[Alf]

Glad to be of help! Thanks for feedback.

Alf