Thanks much works now

"Bob Phillips" wrote:

It should be

Private Sub CommandButton1_Click()
Application.Run "2006vets.xls!Macro1"
End Sub

but if it is the same workbook, you don't even need Application.Run, just

Call Macro1


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Curt" wrote in message
...
Private Sub CommandButton1_Click()
Application.Run ("2006vets.xls.Macro1")
End Sub
This macro is module17 in the workbook. Yet it says it cannot find. Useing
a
command button. The workbook is opened and the form comes up. I must be
missing something.
any help is appreciated
Thanks