View Single Post
 
Old 08-05-2020, 08:26 AM
lerxx lerxx is offline Windows 10 Office 2013
Novice
 
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