Anchor Graphic (XP)

Topic

New Reply

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?

Reply | Quote

Replies

to you too!

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

Reply | Quote

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

^ 2

Reply | Quote

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.

Reply | Quote

Is the size of the graphic open to VBA?

Reply | Quote

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.

Reply | Quote