Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-28-2013, 03:07 AM
Catty Catty is offline Document_ContentControlOnExit Windows 7 32bit Document_ContentControlOnExit Office 2010 32bit
Advanced Beginner
Document_ContentControlOnExit
 
Join Date: Nov 2013
Posts: 39
Catty is on a distinguished road
Post Document_ContentControlOnExit

Hi,

I have a set of dependant content controls (Master and Slave).
If Master.text = "NO" then Slave.text is set to "YES", then a msgbox displays and depending on the options selected from the msgbox the doc is disabled from
editing and the above content controls are locked from editing aswell. All the code is placed in the "Private Sub Document_ContentControlOnExit".



Even though the content controls are locked, a user can still "attempt" to change the text within (which will not change ofcourse), my issue is - when the user steps out of the content control the "Private Sub Document_ContentControlOnExit" is triggered again. How do I stop this or turn it off?

Any ideas?
Reply With Quote
 



Other Forums: Access Forums

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