Hiding Command Buttons before PDF

macropod · #1 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

ksigcajun · #2 05-07-2014, 05:15 AM

Thanks MacroPod. I'll use the code tags from now on.

When you referenced using a second macro to create the PDF and email, plus the delete the command button and add it back, why can't I use the macro I currently have built to do it?

Can't I just add a delete command button function and have it add it back once the PDF has been created and put into an email?

What code would delete a command button and add it back?

Thanks!

macropod · #3 05-07-2014, 05:31 AM

Quote:

Originally Posted by ksigcajun

When you referenced using a second macro to create the PDF and email, plus the delete the command button and add it back, why can't I use the macro I currently have built to do it?

That's just a precaution. I haven't tested it but I was concerned that deleting the button from the macro that runs it might kill the macro. If that doesn't occur, then it should be OK.

Quote:

What code would delete a command button and add it back?

You could use code like:

Code:

Me.CommandButton111.Select
Selection.Delete
'do your printout here
ActiveDocument.Undo

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