Disabling the Office 2010 Security misery

Sure, Security is something we all must take into account. Especially a system administrator. But we need to find a balance between security and workability.

Office 2010 is a good example of a suite which regularly returns to lower security. End-users do not want to get bothered by security pop-ups or notifications of the Office suite, they want to use their macro file and open files from unsecure places.

Let us once and for all put an end to this Office 2010 security misery:

 

The protected view forbids us to edit documents.
To disable the protected view use the following register keys.

This suppresses the message:

‘Protected View. This file originated from an Internet location and might be unsafe. Click for more details. Enable editing’
You can expand them for other Office 2010 components by copying the rules and change the name after 14.0\

 

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Policies\Microsoft\office\14.0\word\security\protectedview]
"DisableIntranetCheck"=dword:00000001
"DisableUnsafeLocationsInPV"=dword:00000001
"DisableInternetFilesInPV"=dword:00000001
"DisableAttachmentsInPV"=dword:00000001

[HKEY_CURRENT_USER\Software\Policies\Microsoft\office\14.0\excel\security\protectedview]
"DisableIntranetCheck"=dword:00000001
"DisableUnsafeLocationsInPV"=dword:00000001
"DisableInternetFilesInPV"=dword:00000001
"DisableAttachmentsInPV"=dword:00000001

[HKEY_CURRENT_USER\Software\Policies\Microsoft\office\14.0\access\security\protectedview]
"DisableIntranetCheck"=dword:00000001
"DisableUnsafeLocationsInPV"=dword:00000001
"DisableInternetFilesInPV"=dword:00000001
"DisableAttachmentsInPV"=dword:00000001

Next, let’s enable the use of macro’s because macro’s can be useful for end-users. This suppresses the message:

‘Security warning: Macro’s are disabled. Enable content’

You can expand them for other Office 2010 components by copying the rules and change the name after 14.0\

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Security]
"VBAWarnings"=dword:00000001

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Word\Security]
"VBAWarnings"=dword:00000001

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\PowerPoint\Security]
"VBAWarnings"=dword:00000001

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security]
"VBAWarnings"=dword:00000001

 

Last, but not least, let’s take a look at how to open Office files directly from the internet. This suppresses the message:

‘Do you want to run or save this file?’

We need to add the file types to the registry. You can find the description in the registry at HKCR\.FILETYPE

Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Windows\Shell\AttachmentExecute\{0002DF01-0000-0000-C000-000000000046}]
"AcroPDF.PDF"=hex:
"Word.Document.8"=hex:
"Word.Document.12"=hex:
"Excel.Sheet.8"=hex:
"Excel.Sheet.12"=hex:
"AcroExch.Document.11"=hex:

 

Well these are the most basic changes to make the life of the end-user a bit convenient.

 

Can’t get the solution to work? Contact me and let me do the trick.

 

 

 

Advertisements
This entry was posted in Microsoft General and tagged . Bookmark the permalink.

One Response to Disabling the Office 2010 Security misery

  1. Steve says:

    Great stuff! The key locations changed in Office 2013, but a quick search for “protectedview” revealed them.
    HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Excel\Security\ProtectedView
    HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Word\Security\ProtectedView

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s