View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default hiding picture while printing

Why not just
rightclick on the picture
select format picture
Properties tab
uncheck the Print object box

But this kind of code will toggle that setting:

Option Explicit
Sub testme()
Dim myPict As Picture
With ActiveSheet
Set myPict = .Pictures("Picture 1")
myPict.PrintObject = False
.PrintOut preview:=True
myPict.PrintObject = True
End With
End Sub

ermeko wrote:

hi,
i need to hide a picture in excel while printing programatically.

thanks,


--

Dave Peterson