Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-09-2014, 06:12 AM
mtbmxrider mtbmxrider is offline Hiding ActiveX Control When Converting To PDF Windows XP Hiding ActiveX Control When Converting To PDF Office 2010 32bit
Novice
Hiding ActiveX Control When Converting To PDF
 
Join Date: Jul 2014
Posts: 2
mtbmxrider is on a distinguished road
Question Hiding ActiveX Control When Converting To PDF

Hello MS users,

I'm a relatively new user to VBA in Word (2 months).

I have created a macro-enabled template with some content controls and added an ActiveX button that scans the document for any controls with illogical content (e.g. numbers in a character field).

I wish to have this button hidden when I convert the document to PDF (and hence the final version).

If possible, I don't want users to have to delete the button manually prior to converting to PDF.



Is there any way I can achieve this through VBA?

Thank you.
Reply With Quote
  #2  
Old 07-09-2014, 05:03 PM
macropod's Avatar
macropod macropod is offline Hiding ActiveX Control When Converting To PDF Windows 7 32bit Hiding ActiveX Control When Converting To PDF Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

Instead of using the ActiveX button (which isn't supported on Macs, BTW, if that matters), you do better to simply assign the macro to a keyboard shortcut. Better still would be to call it from Word's 'BeforeSave' and/or 'BeforePrint' events, so it runs automatically without the user having to remember to do so. See: http://word.mvps.org/FAQs/MacrosVBA/...tSavePrint.htm
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 07-10-2014, 05:58 AM
mtbmxrider mtbmxrider is offline Hiding ActiveX Control When Converting To PDF Windows XP Hiding ActiveX Control When Converting To PDF Office 2010 32bit
Novice
Hiding ActiveX Control When Converting To PDF
 
Join Date: Jul 2014
Posts: 2
mtbmxrider is on a distinguished road
Default

Thanks very much Paul. I'll move ahead with your advice.
Reply With Quote
Reply

Tags
activex control, pdf, save



Similar Threads
Thread Thread Starter Forum Replies Last Post
Prevent ActiveX Button Control from Deleted screech Word 0 06-24-2014 07:29 AM
How to use an ActiveX Control to insert a multi select listbox in Word marksm33 Word 2 01-29-2014 05:21 PM
activex windows media player control Boo Excel 0 04-25-2013 05:48 PM
ActiveX control to list directory trew Office 1 04-17-2012 11:37 PM
Office Update ActiveX Control failed to load tjhkckc Office 1 05-04-2006 10:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:12 AM.


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