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

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

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

useing option buttons some work with call others don't. anyway all are
working. Problem now a dot apears in circle in front of name. If I close and
return the dot reapears in same location. Can not activate till itis gone.
Have a blank option button that I check on it moves to that option then other
one will work. Is there a properties value I am not seeing to remove this dot.
Thanks Again

"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

Just to let you know I found the property that was causeing the problem
Thanks

"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