first user form
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
|