first user form
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 |
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 |
first user form
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 |
first user form
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 |
first user form
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 |
All times are GMT +1. The time now is 03:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com