Calling btn_Click event from different sheets

[shsassy]

Hello,

I was wondering if there is a way to call the btn_click event from different worksheets. I have a main sheet and when the user changes currencies i would like to automatically have a certain button pressed from different worksheets. I have tried recording this as a macro but all that appears is the sheet change. Any ideas?

Thanks,

Sassy

[shg]

A button from the Controls toolbox?

[shsassy]

Yes, they are from the controls toolbox. They are calculate buttons...I called both of them btnCalculate as they are on different worksheets.

[shg]

Rather than calling the click event for a button on another sheet, have the click event call a routine in a code module (which is better practice anyway). Then buttons on other sheets can call the same routine.

[shsassy]

Yeah I guess you are right, that works too. Just looking for the easiest way out :P

Thanks