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

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

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

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.

LeeHarris wrote:

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

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

On Aug 22, 2:27 pm, Dave Peterson wrote:
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.

LeeHarris wrote:

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

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

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

Excellent point that applies to xl2007.

Ferris wrote:

<<snipped

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

--

Dave Peterson