ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   VBA codes (https://www.excelbanter.com/excel-discussion-misc-queries/193551-vba-codes.html)

Emdad

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.

Bob Phillips

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.




Emdad

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)



Bob Phillips

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)





Emdad

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