Printing an object (xl2000 sr1)

Topic

New Reply

Hello,

I have a small gif picture on Sheet1. Using VBA, how do I control the “Print Object” checkbox on the Properties tab of the Format Picture dialog. I just can’t seem to find the property.

Thanks,
Ken

Reply | Quote

Replies

Hi Ken,

If you select the object, you can use:

With Selection
.PrintObject = False ‘ to prevent printing, or True if you want it to print
End With

The same holds for the various other ways of specifying the object(s) on which you might want to set the PrintObject property.

Cheers

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

Mac,

Thanks for the help. Seems simple enough, just not intuitive. At least to me, at least not yet.

Ken

Reply | Quote