VBA codes
I have created an excel file in excel 2007. It contains some VBA codes. I
worked fine first time I have created. I saved it as macro-enabled excel file. Set the sceurity levels to the lowest level. But after I open the excel file the codes are not running. Also, they can't be run from Visual basic Editor immediate window. |
VBA codes
Did you save it again as a 2003 file?
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Emdad" wrote in message ... I have created an excel file in excel 2007. It contains some VBA codes. I worked fine first time I have created. I saved it as macro-enabled excel file. Set the sceurity levels to the lowest level. But after I open the excel file the codes are not running. Also, they can't be run from Visual basic Editor immediate window. |
VBA codes
Thanks Bob for your prompt reply. Actually the file is one of my colleagues.
Yes, he has saved it as excel 2003. Then re-created the function as saved as macro enabled xl file. Pls suggest. - Emdad "Bob Phillips" wrote: Did you save it again as a 2003 file? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) |
VBA codes
I have heard there are problems doing that. Let me do some tests and get
back to you. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Emdad" wrote in message ... Thanks Bob for your prompt reply. Actually the file is one of my colleagues. Yes, he has saved it as excel 2003. Then re-created the function as saved as macro enabled xl file. Pls suggest. - Emdad "Bob Phillips" wrote: Did you save it again as a 2003 file? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) |
VBA codes
Thanks in advance, Bob
- Emdad "Bob Phillips" wrote: I have heard there are problems doing that. Let me do some tests and get back to you. -- HTH Bob |
All times are GMT +1. The time now is 09:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com