Macro Security Level - High Priority

[Guest]

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.

 

[Guest]

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.

 

[Dave Peterson]

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.)

 

[Guest]

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?

 

[Guest]

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.

 

[Harald Staff]

Denise

It's a registry value for each user:
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\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

 

[JE McGimpsey]

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

 

[Dave Peterson]

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

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.

 

[Guest]

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.