The reason the poster is having trouble is that he did not assign routines to his buttons. The code he wants to run is in the
button_click event on his form. Your solution will be fine after he moves all of that code that he doesn't want to copy into
seperate subroutines. Until then, he cannot solve his problem. Your solution would be obvious if he had already assigned routines to
his click events instead of putting his code there. If he had known enough about VBA to have his code in seperate subroutines and
assigning them, assuming that his code doesn't also manipulate the form and its controls, he would already know enough not to need
our help.
--
RMC,CPA


"bill k" wrote in message
...

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