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.
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..