Printing an object (xl2000 sr1)

[kjktoo]

<img src=/S/hello.gif border=0 alt=hello width=25 height=29> 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

[macropod]

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

[kjktoo]

Mac,

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

Ken