Precise positioning of a graphic in Excel

[fishbin]

I'd like to precisely place a jpg in an Excel worksheet.

I realize that graphics float on top, but is there a way to position them relative to a cell.

Can I do it with a formula in a cell (yes I'm a newbie) or do I need to use a macro?

fish

 

[SkipVought]

Hi,

With oSomeObj
  .top = SomeCell.top
  .left = SomeCell.left
End With

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[byundt]

fish,
Without using VBA, you can "lock" a graphic to a certain cell by:
1) Right-click the graphic. Choose Format Picture from the resulting popup.
2) Go to the Properties tab
3) Make sure the option is selected for either "Move but don't size with cells" or "Move and size with cells"

If the drawing grid is turned on, then you may find it difficult getting the picture exactly where you want. To turn the drawing grid off:
1) Open the View...Toolbars menu item
2) Select the Drawing toolbar
3) On the Drawing toolbar, select the Draw...Snap menu item
4) Make sure that nothing is selected in this dialog

Brad