This might be the long way, if anybody else has suggestions, i won't get my feelings hurt
: (1) For a different button for each form to send to excel: I would create one macro. Make sure you have the "Macro Names" icon clicked on the tool bar. Name your macros like Form1 then put in the arguments for that form then For your second form, in the macro names colomn, put form2 then enter your arguments. This is for if you have a single button for each form that you want to send to excel. Then in the On_Click Property for your button you would select Macroname.Form1 For the 2nd form and second button you would select macroname.form2.
(2)If you have one button and you want this one button to send all of your forms to excel... just don't enter anything in the macronames, but have all your actions for your different forms. If this sounds confusing let me know and i'll send you a screen shot of what your macros would look like.