That depends entirely on what kind of buttons you have. There are 2 types of
buttons. Buttons from the forms toolbar attach to macros stored in standard
code modules. To run those you can just run the macro's. You may need to
select the appropraite sheet with the buttons prior to calling the macros if
the code references the active sheet. If the buttons are from the control
toolbox then the code can be run by changing the scope fo the button from
private to public and then you can access the button fairly easily. Let me
know which buttons you have if you need more info that this...
--
HTH...

Jim Thomlinson


"Ian" wrote:

I have a workbook with 6 sheets inside.
5 have data and each have one button to process the data.

i require to run each button from the first sheet to get a summary
of the data.

how do i call the buttons on the other sheets and display the data
on the first.

thanks