Don't Print Autoshape Macro

E

EMoe

Good Evening Programmers!

How do I add to my print code a command that will not print the macro
button which is an "autoshape". In other words, print the selected
page, but don't show the macro button on the printed sheet.

Example of my print code:

Sub Printsheet ()
Application.ScreenUpdating = False
Range("A1:M37").Select
Selection.PrintOut Copies:=CLng(num), Collate:=True
Range("A1").Select
Application.ScreenUpdating = True
End Sub

Thanks,
EMoe
 
N

Norman Jones

Hi Emoe,

Right-Click the autoshape | Format Autoshape | Properties
Deselect the Print option.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top