Excel XP Standard 2002, SP2 - We are running excel on Citrix servers and the
software automatically set the macro security level to HIGH and we know that
it can be change by each user. BUT where can this be changed for all users
to Medimun.
--
Denise

Denise,
Open Excel at the users station, Go to the 'Tools' Drop down menu, and
Choose 'Options', then on the Security Tab Click Macro Security, then change
the radio button.

Alex A.

"Denise" wrote:

Excel XP Standard 2002, SP2 - We are running excel on Citrix servers and the
software automatically set the macro security level to HIGH and we know that
it can be change by each user. BUT where can this be changed for all users
to Medimun.
--
Denise

As my email stated we know how to change per user but would like to know how
to change for all users. Do you know how that can be accomplished? Can a
macro be written at the beginning of the program to change this option?
--
Denise


"Alex A." wrote:

Denise,
Open Excel at the users station, Go to the 'Tools' Drop down menu, and
Choose 'Options', then on the Security Tab Click Macro Security, then change
the radio button.

Alex A.

"Denise" wrote:

Excel XP Standard 2002, SP2 - We are running excel on Citrix servers and the
software automatically set the macro security level to HIGH and we know that
it can be change by each user. BUT where can this be changed for all users
to Medimun.
--
Denise

Maybe your network admins can change this level, but the purpose of this is to
be able to stop macros from running without the user's consent.

If you could write an excel macro that could change this setting, then you would
defeating the purpose of the option. (and make it so that any malicious code
author could do bad things with or without your consent.)

Denise wrote:

Excel XP Standard 2002, SP2 - We are running excel on Citrix servers and the
software automatically set the macro security level to HIGH and we know that
it can be change by each user. BUT where can this be changed for all users
to Medimun.
--
Denise

--

Dave Peterson

Do you know how to write a macro to change this each time we run an excel
program? This way when they get out of Excel it will reset itself back to
HIGH.
--
Denise


"Dave Peterson" wrote:

Maybe your network admins can change this level, but the purpose of this is to
be able to stop macros from running without the user's consent.

If you could write an excel macro that could change this setting, then you would
defeating the purpose of the option. (and make it so that any malicious code
author could do bad things with or without your consent.)

Denise wrote:

Excel XP Standard 2002, SP2 - We are running excel on Citrix servers and the
software automatically set the macro security level to HIGH and we know that
it can be change by each user. BUT where can this be changed for all users
to Medimun.
--
Denise

--

Dave Peterson

Again, the ability of macros to change macro security settings is not
present.


In article ,
Denise wrote:

Do you know how to write a macro to change this each time we run an excel
program? This way when they get out of Excel it will reset itself back to
HIGH.

If macros are disabled, then they won't run. You can't change this from within
excel.



Denise wrote:

Do you know how to write a macro to change this each time we run an excel
program? This way when they get out of Excel it will reset itself back to
HIGH.
--
Denise

"Dave Peterson" wrote:

Maybe your network admins can change this level, but the purpose of this is to
be able to stop macros from running without the user's consent.

If you could write an excel macro that could change this setting, then you would
defeating the purpose of the option. (and make it so that any malicious code
author could do bad things with or without your consent.)

Denise wrote:

Excel XP Standard 2002, SP2 - We are running excel on Citrix servers and the
software automatically set the macro security level to HIGH and we know that
it can be change by each user. BUT where can this be changed for all users
to Medimun.
--
Denise

--

Dave Peterson


--

Dave Peterson

Denise

It's a registry value for each user:
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\E xcel\Security\Level

A macro can change that key, once enabled, so can probably a setup program
and some network administrator weapons. It is not considered good practice
to change macro security with a macro.

HTH. Best wishes Harald

"Denise" skrev i melding
...
Excel XP Standard 2002, SP2 - We are running excel on Citrix servers and
the
software automatically set the macro security level to HIGH and we know
that
it can be change by each user. BUT where can this be changed for all
users
to Medimun.
--
Denise

This is an old question, but I have a problem. I've done this change
(below), I've used "Custom Installation Wizard", and nothing seems to work.
Excel still forces security to "High" and does not trust VBA. I'm at my
wit's end. I''ve also re-installed Excel 2003 several times, and nothing
seems to work.


"Harald Staff" wrote:

Denise

It's a registry value for each user:
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\E xcel\Security\Level

A macro can change that key, once enabled, so can probably a setup program
and some network administrator weapons. It is not considered good practice
to change macro security with a macro.

HTH. Best wishes Harald

"Denise" skrev i melding
...
Excel XP Standard 2002, SP2 - We are running excel on Citrix servers and
the
software automatically set the macro security level to HIGH and we know
that
it can be change by each user. BUT where can this be changed for all
users
to Medimun.
--
Denise