thanks for your help.
cheers

On Wed, 12 Apr 2006 09:16:02 -0700, Jim Thomlinson
wrote:

Assuming you have a button embeded in sheet1 (code name) called
CommandButton1...

goto to the code for the buttons and change it to Public...
Public Sub CommandButton1_Click()

Now in a sub in sheet 2 you should be able to reference the button using
Sub TestButtons
Call Sheet1.CommandButton1_Click
end sub