setting excel 2000 macro security

M

mari

is there a way to set the excel 2000 macro security level to Medium via
scripting or registry changes?

i have excel on terminal server and would like to set it so that al users
receieve medium level.
 
H

Harald Staff

Sure. The key is
HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Security\Level
- set it to 2

Andy is correct, this isn't good practice at all. But Medium isn't too
dangerous unless you run a bank or an army, and I take it that your company
agrees to this action.

HTH. Best wishes Harald
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro security cannot be changed 2
Security level from commadn line 1
Macro security level 6
Suppress macro warning on my own workbooks? 3
XL 2007 Macro Security warning 1
macro security 1
Excel 2003 sticks to the low macro security level 14
Macro Security Setting 1

Top