#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VB Codes bowling Excel Discussion (Misc queries) 0 July 30th 07 07:02 PM
Bar Codes [email protected] Excel Discussion (Misc queries) 4 August 31st 05 08:12 AM
ZIP CODES js42 Excel Worksheet Functions 2 August 5th 05 03:59 PM
Zip Codes Queen Excel Discussion (Misc queries) 3 February 18th 05 03:47 PM
Zip Codes [email protected] Excel Discussion (Misc queries) 10 November 27th 04 06:23 PM


All times are GMT +1. The time now is 08:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"