Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB Codes | Excel Discussion (Misc queries) | |||
Bar Codes | Excel Discussion (Misc queries) | |||
ZIP CODES | Excel Worksheet Functions | |||
Zip Codes | Excel Discussion (Misc queries) | |||
Zip Codes | Excel Discussion (Misc queries) |