Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-05-2020, 08:26 AM
lerxx lerxx is offline VBA - Document protection with exceptions Windows 10 VBA - Document protection with exceptions Office 2013
Novice
VBA - Document protection with exceptions
 
Join Date: Oct 2019
Posts: 2
lerxx is on a distinguished road
Default VBA - Document protection with exceptions

Hello,

we are using the protection function in word with "exceptions", so that users can only edit defined ranges. Is it possible to disable, or if not, to delete the exceptions ranges, so that we can have an final document at the end?

Usually we would use the protectiontype wdallowonlyreading, but this is the same as required for the exceptions.

If ActiveDocument.ProtectionType = wdNoProtection Then
ActiveDocument.Protect Password:="", noReset:=False, Type:= _


wdAllowOnlyReading, UseIRM:=False, EnforceStyleLock:=False
End If

Thanks in advance!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help Customizing Document Protection bgmsd Word 2 06-07-2015 07:31 AM
VBA - Document protection with exceptions Document enables protection after print ubns Word 1 09-12-2012 06:33 PM
VBA - Document protection with exceptions Protection bounces user to top of document aedmyr Word 2 04-13-2012 08:32 PM
Document protection Daved2424 Word 0 11-17-2010 01:22 AM
VBA - Document protection with exceptions need help with document protection jknyc Word 1 06-22-2009 11:47 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:57 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