Hiding Command Buttons before PDF

macropod · #2 05-06-2014, 04:23 PM

If this is an ActiveX command button, you could pass the processing off to a second macro that handles the PDF creation & emailing. As part of that process, it could delete the command button, then restore it again (via Application.Undo) after the PDF has been created.

PS: When posting code, please use the code tags. They're on the 'Go Advanced' tab at the bottom of this screen.
PPS: You could reduce:

Code:

         ActiveDocument.ExportAsFixedFormat OutputFileName:=PDFname, _
          ExportFormat:=wdExportFormatPDF, OpenAfterExport:=False, _
          OptimizeFor:=wdExportOptimizeForPrint, Range:=wdExportAllDocument, _
          Item:=wdExportDocumentContent, IncludeDocProps:=True, KeepIRM:=True, _
          CreateBookmarks:=wdExportCreateNoBookmarks, DocStructureTags:=True, _
          BitmapMissingFonts:=True, UseISO19005_1:=False

to:

Code:

        ActiveDocument.SaveAs2 FileName:=PDFname, FileFormat:=wdFormatPDF

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Command buttons on slidemaster	chcope	PowerPoint	2	06-13-2013 04:30 PM
Check Boxes and Command Buttons	Micky P	Word VBA	0	10-27-2011 01:06 AM
Command Buttons	lorenambrose	Word	0	10-06-2011 11:55 AM
command buttons	ronf	Excel	0	04-28-2006 08:32 AM
command buttons	ronf	Excel	0	12-03-2005 06:26 AM