View Single Post
 
Old 02-06-2014, 11:04 AM
NobodysPerfect NobodysPerfect is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Jan 2014
Location: Germany
Posts: 136
NobodysPerfect is on a distinguished road
Default Disable Shade Editable Ranges globally

Hi,

I do know I can disable the "Shade Editable Range" option with a single code line in a Document_Open macro
Code:
ActiveWindow.View.ShadeEditableRanges = False
But what can I do, if macros/'dotm' files are not allowed. It' an annoying feature that any time when opening a document with editing restricted areas the user has to open the Protect/Unprotect pane for disabling these yellow shades. It is the customers wish to open the respective documents without yellow shading - and without macro.

Is there any (well hidden) setting I do not know, or - a question for the VBA cracks - a code line for the normal.dot that globally disables this option (not only for the active window)?

Any help welcome
Reply With Quote