You need to make them Public.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pete at Sappi Fine Paper"
wrote in message ...
Okay, next question: it works if the button is on the same sheet as the
"master button", but what if the button is on another sheet? I tried:

cmdReport_Click

...and...

Worksheets("Sheet2").cmdReport_Click

and I got an error 438 - "Object doesn't support this property or method".

Any thoughts?

"HotRod" wrote:

I think you can call the "CommandButton_Click" EVENT for each button to
launch what you want.