Hi ~

I am using XL 2000. I am trying to run a macro that has parameters in
it. The macro works fine if I have Security level set to "low".
However, if change the security level to "Medium", which all my
clients are using, the macro doesn't work anymore. In fact, nothing
happens.

So, is there a way to run a parameterized macro in medium or high
security? If so, could you provide me with the code to do so for XL
2000. There seems to be an option for Office XP and later versions,
but can't find one for XL 2000.

Thanks in advance.

What do you mean by a Parameterized macro?

"Phantom" wrote:

Hi ~

I am using XL 2000. I am trying to run a macro that has parameters in
it. The macro works fine if I have Security level set to "low".
However, if change the security level to "Medium", which all my
clients are using, the macro doesn't work anymore. In fact, nothing
happens.

So, is there a way to run a parameterized macro in medium or high
security? If so, could you provide me with the code to do so for XL
2000. There seems to be an option for Office XP and later versions,
but can't find one for XL 2000.

Thanks in advance.

Unless I'm missing something, I see no connection between "parameters"
(arguments ?) and security.
Macro either run or they don't.
With security set to medium, the users are clicking Yes when prompted
whether to allow macros ?

NickHK

"Phantom"
groups.com...
Hi ~

I am using XL 2000. I am trying to run a macro that has parameters in
it. The macro works fine if I have Security level set to "low".
However, if change the security level to "Medium", which all my
clients are using, the macro doesn't work anymore. In fact, nothing
happens.

So, is there a way to run a parameterized macro in medium or high
security? If so, could you provide me with the code to do so for XL
2000. There seems to be an option for Office XP and later versions,
but can't find one for XL 2000.

Thanks in advance.