i have 3 different sheets with a private sub on each all labelled

Private Sub CommandButton1_Click()

the macro's runs fine on each page.

i want to put a macro on a separate sheet that i can run each of those macro's

i did initially copy the original private macro and change the

Private Sub CommandButton1_Click()

to

sub report()

but i couldnt do all 3 in the same manner. i did change each name to something different... the other 2 subs did run, but they didnt do anything except put the massage box on the end saying that "the macro has finished".

the private macros are on sheets 26, 28 and 12.


please help