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
|