Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-06-2014, 11:04 AM
NobodysPerfect NobodysPerfect is offline Disable Shade Editable Ranges globally Windows 7 64bit Disable Shade Editable Ranges globally Office 2010 32bit
Competent Performer
Disable Shade Editable Ranges globally
 
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
  #2  
Old 02-07-2014, 08:34 PM
macropod's Avatar
macropod macropod is offline Disable Shade Editable Ranges globally Windows 7 32bit Disable Shade Editable Ranges globally Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by NobodysPerfect View Post
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disable Shade Editable Ranges globally 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:25 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft