Results 1 to 6 of 6
  1. #1
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Anchor Graphic (XP)

    Bananas to Everyone!

    I have a graphic that I am adding to a sheet. When I add the graphic, I can anchor it to the left side so moving columns around doesn't move the graphic - as long as I don't move the left side. However, what I actually want to do is anchor using the right side - can I do that? How?
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Anchor Graphic (XP)

    <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35> to you too!

    Right side of what? The graphic, the Excel window, the worksheet, the screen, or ...?

  3. #3
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Anchor Graphic (XP)

    Ahh - I want to anchor the right side of the graphic to the right side of a cell.

    <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35> ^ 2
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Anchor Graphic (XP)

    That is not really possible, or not in the way you probably want.
    If you set the graphic to 'move and size with cells' in the Properties tab of Format | Picture..., you can anchor the right side of the graphic to the right edge of a cell by resizing or moving with the Alt key held down until the right side snaps to the edge of a cell. BUT ... moving the column border will resize the picture instead of moving it. I don't think there is a way of attaching the graphic to the right edge of a cell and keeping the size constant.

  5. #5
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Anchor Graphic (XP)

    Is the size of the graphic open to VBA?
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Anchor Graphic (XP)

    Yes, a Shape object has Width and Height properties. E.g.

    ActiveSheet.Shapes(1).Width = Application.InchesToPoints(2)

    Note: by default, the LockAspectRatio property will be True, so if you change Width, you'll also change Height. You must set LockAspectRatio to False if you want to resize in one dimension only.

Posting Permissions

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