View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
EMoe[_103_] EMoe[_103_] is offline
external usenet poster
 
Posts: 1
Default Don't Print Autoshape Macro


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


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=505643