Hiding Command Buttons before PDF

ksigcajun · #1 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 · #2 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