What kind of button - From the Forms toolbar or a commandbutton from the
Control Toolbox toolbar?

You want to make your five macros 1 macro?

--
Regards,
Tom Ogilvy

"Chris" wrote in message
...
Hello all,

I am new to this level of macros. I have the following:

Sub CritSuccessFY04()
'
' PrintFY04AccntAcq Macro
' Macro recorded 12/3/2003 by cwilson
'

'
Sheets("Monthly Summary").Select
Range("E215:P233").Select
ActiveSheet.PageSetup.PrintArea = "$E$215:$P$233"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
ActiveSheet.PageSetup.PrintArea = ""
Sheets("Print Macros").Select
End Sub

I have a least 5 macros and I want them to run for different sheets if a
different button is pressed. Can this be done without copy the macro over
and over? I have a lot of sheets.

Thanks in advance.