Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 07-07-2017, 06:48 AM
gmaxey gmaxey is offline Drop down with warning Windows 7 32bit Drop down with warning Office 2016
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,440
gmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the rough
Default

You guess?



Code:
Private Sub Document_ContentControlOnExit(ByVal ContentControl As ContentControl, Cancel As Boolean)
Msgbox "You exited a CC so I fired"
Select Case ContentControl.Tag
Case "type"
   Msgbox "Since my tag is ""type"" I'm going to keep cooperating."
If ContentControl.Range.Text = "Litigation / Litige" Then MsgBox "Some notification"
End Select
End Sub
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #17  
Old 07-07-2017, 06:55 AM
pharrison pharrison is offline Drop down with warning Windows 10 Drop down with warning Office 2010 64bit
Novice
Drop down with warning
 
Join Date: Jul 2017
Posts: 12
pharrison is on a distinguished road
Default here is the file

Ok here is the file. Nothing secret about it.
Attached Files
File Type: docm NEW FILE REQUEST Form .docm (46.3 KB, 8 views)
Reply With Quote
  #18  
Old 07-07-2017, 07:09 AM
gmaxey gmaxey is offline Drop down with warning Windows 7 32bit Drop down with warning Office 2016
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,440
gmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the rough
Default

There is nothing wrong with the event. It is doing exactly what it is coded to do. You CC list item has a trailing space in it. Fix that or add the space to the code and it will work fine.
Attached Images
File Type: jpg 2017-07-07_10-05-00.jpg (93.1 KB, 13 views)
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #19  
Old 07-07-2017, 07:12 AM
pharrison pharrison is offline Drop down with warning Windows 10 Drop down with warning Office 2010 64bit
Novice
Drop down with warning
 
Join Date: Jul 2017
Posts: 12
pharrison is on a distinguished road
Default

I have both taken it out and tried. As well put one in.. Still same issue.

Nothing happens
Reply With Quote
  #20  
Old 07-07-2017, 07:49 AM
gmaxey gmaxey is offline Drop down with warning Windows 7 32bit Drop down with warning Office 2016
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,440
gmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the rough
Default

Nothing happens is not very helpful. If you won't help yourself then there is little I can do. The code works fine as I hope the zipped video will illustrate.

Do you have macros enabled with notification in your Trust Center settings?
Attached Files
File Type: docm NEW FILE REQUEST Form .docm (48.2 KB, 8 views)
File Type: zip Demo.zip (481.2 KB, 7 views)
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #21  
Old 07-07-2017, 07:52 AM
pharrison pharrison is offline Drop down with warning Windows 10 Drop down with warning Office 2010 64bit
Novice
Drop down with warning
 
Join Date: Jul 2017
Posts: 12
pharrison is on a distinguished road
Default Doh

Well looks like the macro settings are disabled by IT here Anyway around this or no?


Sorry

Thanks
Peter
Reply With Quote
  #22  
Old 07-07-2017, 08:46 AM
gmaxey gmaxey is offline Drop down with warning Windows 7 32bit Drop down with warning Office 2016
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,440
gmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the rough
Default

You might ask your IT what is the point of purchasing a flagship Word Processor if they are then going to restrict its performance with global ill thought out settings. It is bit like purchasing and Ferrari and disconnecting a few spark plugs.
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop down with warning Turn off scheduling warning jjmclell Project 3 03-20-2015 07:28 AM
Drop down with warning Privacy warning. freebee2 Excel 4 06-08-2014 11:21 PM
Drop down with warning Outlook Warning Message ajazz Outlook 5 06-11-2011 04:46 AM
Problem with warning message randynovotny Outlook 1 04-20-2011 04:56 PM
Hyperlink Warning gfkbob Outlook 0 01-23-2010 06:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:52 PM.


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