Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Sault Ste. Marie, Michigan, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing an object (xl2000 sr1)

    <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

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Printing an object (xl2000 sr1)

    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
    [MS MVP - Word]

  3. #3
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Sault Ste. Marie, Michigan, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing an object (xl2000 sr1)

    Mac,

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

    Ken

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •