Functions not working in Vista... (custom defined viewable as modules with Alt-F11)

[LeeHarris]

I have an excel sheet in an older vesion, probably Excel 2003, I open
this in Vista but where my cells say "=qcom(blah, blah) it's
evaluating as #NAME like it doesn't recognise the function
"qcom" (which is there)
If i hit Alt-F11, I can see in the "modules" section the relevant page
which includes the qcom function.

I suspect this is some feature of Vista that's disallowing these
functions to run, but how to enable it?
thanks in advance
Lee

 

[Dave Peterson]

I wouldn't guess that the version of windows has much to do with this.

But if you changed the version of excel (or just installed xl2003), maybe your
security settings aren't what you want them to be.

In xl2003, close that workbook and toggle that setting:
tools|macro|security|security level tab

In xl2007, you should see a warning banner(?) when you open the workbook saying
that macros are disabled. You can choose to enable macros there.

 

[Ferris]

I wouldn't guess that the version of windows has much to do with this.

But if you changed the version of excel (or just installed xl2003), maybe your
security settings aren't what you want them to be.

In xl2003, close that workbook and toggle that setting:
tools|macro|security|security level tab

In xl2007, you should see a warning banner(?) when you open the workbook saying
that macros are disabled. You can choose to enable macros there.

You may need to save your file as Macro-enabled worksheet in order for
it to work.

 

[Dave Peterson]

Excellent point that applies to xl2007.

You may need to save your file as Macro-enabled worksheet in order for
it to work.