Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 03-13-2016, 06:58 PM
macropod's Avatar
macropod macropod is offline Protecting Document via VBA Not Working Windows 7 64bit Protecting Document via VBA Not Working Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

The problem with that approach is that it will trigger the macro on any field titled 'MethodInspect' - which means that content control in any row. You might get better results by changing:
i = .Range.Tables(1).Range.ContentControls.Count
to:
i = .Range.Tables(1).Range.ContentControls.Count -1
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Tags
protect, unprotect, vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
Protecting Document via VBA Not Working Spell out a number without protecting a document vera Word VBA 2 05-20-2016 07:35 AM
Protecting document brucemc777 Word 2 01-23-2016 02:38 PM
Protecting Document via VBA Not Working Cant type into content controls in a form after protecting document using macro rgburridge Word VBA 4 01-27-2015 02:37 PM
Disabling content controls and protecting document sections. Catty Word VBA 2 11-29-2013 05:10 AM
Protecting Word Document by restricting access permissions! user Word 0 11-20-2008 01:21 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:32 AM.


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