Command Button with Macro on Different Sheet

[mridzuan]

Let say I have a macro in Sheet1 that goes like this:

Private Sub CommandButton1_Click()

xxxxxxx
xxxxx
xxxx

End Sub

If I put CommandButton1 in Sheet2, how can I point the button to the Macro written in Sheet1?

[Mallycat]

eithe refer to the full path sheet1!CommandButton1_Click or put your code in a module sheet rather than on Sheet1