Multiple Custom Footers

[jesstercpa]

I do financial statements here in the office, all of which have standard wording that we use as a custom footer. But I may use one footer during interim reporting periods, and another during year-ends. Can I have multiple custom footers that I can select from the drop down box, or must I manually modify the custom each time? Thank you very much!

 

[Tom Morales]

Jesse -
One approach would be to put that information into your Personal Workbook. You could link that data to a UserForm that would activate at your command.

For example, create a macro short-cut key (eg, Control-e) that would show the form. The form would have the ComboBox with your menu of footers. On choosing one, it would assign that footer to your active workbook.
Tom