Sub doitall()
routine1
routine2
etc.....
End Sub
where routine1 is the name of the sub you assigned to button1
no brackets just the name
--
bill k
------------------------------------------------------------------------
bill k's Profile:
http://www.excelforum.com/member.php...nfo&userid=821
View this thread:
http://www.excelforum.com/showthread...hreadid=470870