Disable Shade Editable Ranges globally

NobodysPerfect · #1 02-06-2014, 11:04 AM

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

macropod · #2 02-07-2014, 08:34 PM

Quote:

Originally Posted by NobodysPerfect

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

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

You could add your code line (perhaps prefixed with 'ActiveDocument.') to a Document_Open macro in the Normal (global) template.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
turn off default formatting globally in powerpoint	juicymixx	PowerPoint	1	02-16-2013 10:06 AM
How to use named ranges in excel vba?	bosve73	Excel Programming	4	01-25-2012 09:26 AM
Globally Embed Fonts?	lwarley	PowerPoint	0	07-24-2011 08:20 AM
Dynamic Named Ranges using text	hannu	Excel	0	06-22-2010 04:42 PM
Help with a macro to shade a selected pie chart	hzrvkt	Excel	0	02-24-2006 01:25 PM