You can use the beforeprint event to have your code add the footers.

To get the code, turn on the macro recorder while you do it manually.

Then open the beforeclose event and put similar code there.

http://www.cpearson.com/excel/events.htm for an overview of event code if
you are not familiar with it.

--
Regards,
Tom Ogilvy

"SmartyPants" wrote:

In there any way to add footers en mass?

I have a rather large and complicated workbook and I would like to add
footers to everything that prints from the workbook.

Is there any code that will add a footer (picture) to anything that
prints from a workbook?

Adding footers to all charts and graphs will take me a couple hours.