Footer

  • Thread starter Thread starter Dennis Saunders
  • Start date Start date
D

Dennis Saunders

I have my email address as the footer in many of my print outs.
Is there a way I can change all of them to my new address at one go?
They are in various files and folders.
Thanks for any help.
Regards Dennis
Alternatively could I have my email address as the default footer? And then
change all footers to this?
 
Hi
not really possible to change all in one go. Would require a macro
which loops through all your workbooks.

But for setting a default create a new workbook with this footer and
save the file as template (*.xlt) and use this template
 
Back
Top