VBA codes

[Emdad]

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.

 

[Bob Phillips]

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]

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]

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]

Thanks in advance, Bob

- Emdad