Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

MS Office

Aug 10, 2005 7:57PM PDT

Hi everybody!
Does anybody know how to create a button which automatically inserts a certain (header and) footer? e.g. in Excel.
I've seen this once but I can't remember where it was..

Discussion is locked

- Collapse -
Re: button and macro
Aug 10, 2005 10:50PM PDT

Borhelstu,

The steps to take:
1. Create (record and/or program) a macro that does what you want.
2. Insert a button and assign the macro to it.

The Excel help will certainly tell you how to do step 2. Step 1 might be more difficult, depending on your wishes.

Kees

- Collapse -
Don'T work
Aug 14, 2005 7:03PM PDT

Yeah I'm trying, but this ain't workin.
Is there maybe some visual basic programing involved? That's something I'm not capable of.
Who can help?

- Collapse -
Re: macro
Aug 15, 2005 4:27AM PDT

If you can record the macro totally, there's no need to program in VBA.
If there are decisions involved, or variable locations of data, you need to program indeed. If you can't do that, you must be much clearer in what you want and why a simple recording of a macro doesn't work (and even then it's doubtful if anybody on this forum will provide you with the exact code you need), or invest some time in learning to program yourself or invest some money in hiring somebody to do it for you.

Kees