Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to Fit AutoShape over Range? | Excel Discussion (Misc queries) | |||
autoshape macro | Excel Discussion (Misc queries) | |||
Autoshape Macro | Excel Programming | |||
Remove macro from autoshape | Excel Programming | |||
AutoShape name assigned to macro | Excel Programming |