Well, it depends. Right click the button and select "View Code". Thi
should appear:

Private Sub CommandButton1_Click()

End Sub

Just type the name of the subroutine inside it like so, if you ar
calling a subroutine called "Foo":

Private Sub CommandButton1_Click()
Foo
End Sub

Or try:

Private Sub CommandButton1_Click()
Call Foo
End Sub

- Piku

--
Message posted from http://www.ExcelForum.com