use this idea
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Normek" wrote in message
...
Hi ceige7979
As L.Howard Kittle says or more simply:
sub Commandbutton_click()
sub1
sub2
sub3
sub4
sub5
end sub

sub1()
...
end sub
etc.

"ceige7979" wrote:

I have 5 seperate macros in one workbook. I want to build one button
that
will run them all. I can not use Access I have to use Excel