Multiple Custom Footers

jesstercpa · Mar 2nd, 2002, 08:56 AM

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 · Mar 4th, 2002, 12:22 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 2nd, 2002, 08:56 AM	#1
jesstercpa New Member Join Date: Mar 2002 Location: Teaneck, NJ Posts: 4	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!

Mar 4th, 2002, 12:22 PM	#2
Tom Morales Board Regular Join Date: Feb 2002 Location: Richland, Washington Posts: 91	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