Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Australia
    Posts
    1,294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Registry Keys for Macro Security Settings Level (OfficeXP SP3)

    Hello

    I've checked both this forum & MS-knowledge base, but couldnt find what I was looking for.

    I'm after the registry key locations and settings to set the MS-applications Macro Security Levels.

    many thanks
    diana <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Quedgeley, Gloucester, England
    Posts
    5,333
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Registry Keys for Macro Security Settings Leve

    If you were to use SysInternal's Regmon you could, with a fair amount of effort, determine what you want by manually changing the settings on an 'unchanged' PC and observing the Regmon results. Best to terminate almost everything else before doing this, to prevent confusion...

    John
    <font face="Script MT Bold"><font color=blue><big><big>John</big></big></font color=blue></font face=script>

    Ita, esto, quidcumque...

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Registry Keys for Macro Security Settings Level (OfficeXP SP3)

    Key: HKEY_CURRENT_USERsoftwareMicrosoftOffice10.0ExcelS ecurity
    Value: Level
    Meaning: macro security, where 1 = Low, 2 = Medium, 3 = High
    Value: DontTrustInstalledFiles
    Meaning: trust all installed add-ins and templates, where 0 or absent = Yes, 1 = No

    Similar for Outlook, PowerPoint and Word.

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Registry Keys for Macro Security Settings Leve

    The Office Resource Kit might document the way to set this in the Policy branch of the registry, if the goal is to take central control of the setting.

  5. #5
    4 Star Lounger
    Join Date
    Feb 2004
    Location
    Saint Charles, Missouri, USA
    Posts
    565
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Registry Keys for Macro Security Settings Leve

    THANK YOU HANS ! ! !

    On a Dell notebook I was just working on, I was having a problem changing the security levels for Excel to run macro's again. For some reason going through Excel, the buttons were grayed out (Tools | Macro | Security) on the Security Menu. After changing the HKCU tree mentioned for Value, I received an error trying to save the value (Duplicate value error).

    A little more investigation revealed the registry was corrupted and cross linked with another file. I'm not sure why scandisk.exe or scanreg.exe did not find the error.

    Managed to restore a backup register and off and running.
    Scott

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •