Microsoft Excel 4.0 Macro -> VBA

[YvorL]

Hello!

I've a few named ranges, most of it in one sheet. This sheet updates itself (when the workbook opened), from a central worksheet. In the other sheets are the drop-down lists. The first problem I had was that some lists are dependent on the value of an other cell. So I named the ranges after these values and gave the list as:

=EVALUATE(INDIRECT(ADDRESS(ROW();5)))

The problem is that every time I open this workbook I got a noticing message that this is a Microsoft Excel 4.0 Macro.
Can I get rid of that somehow?
Like:
- there is an option to turn this message (and only this) of in this (and only this) workbook
or
- there is a macro doing the equivalent stuff

Thank You!

 

[RoryA]

Looks like I was a bit too optimistic. As soon as I changed the named ranges to dynamic it stopped working Any suggestion?

Not offhand - I tested it with dynamic ranges before posting and it worked, albeit in excel 2011. Will try 2010 later when I have a chance

 

[RoryA]

Tested it in 2010 and it works there too. Are you sure your named ranges are evaluating correctly?

 

[YvorL]

Yes. I tried it individually and it works there.
I named only one range dynamically and the other list (where "mylist" is) works on every other named range. So the function is working too.
But (as I mentioned above) we use mso 2003 .

 

[YvorL]

Nothing?

 

[RoryA]

Nothing?

I don't currently have 2003 installed anywhere - will set something up for testing tomorrow.

 

[YvorL]

I don't currently have 2003 installed anywhere - will set something up for testing tomorrow.

Neat!
Thank You in advance!
Also I've tried in MSO 2010 and it somehow didn't work there either....
Can you send me a file? (maybe I've done something wrong )

 

[RoryA]

I think you must have done something as I have just tested it in 2003 and it works there too
Sample file here. (hopefully!)