Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 12:20 PM.


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