Any object added to a worksheet is placed in a drawing layer above (in front
of) the worksheet cells. The add-in you mention may appear to put objects
into the cells, but it does not. It may give this effect by carefully sizing
and positioning the object, then selecting Move and Copy With Cells (Format
Object Properties tab), which in VBA is Object.Placement = xlMoveAndSize.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"Ray Men" <Ray
wrote in message
...
I have problems with hundreds of shapes lying on the cells while working
with
the sheet (sorting, resizing, etc). The shapes/Objects become missplaced,
oversized, unrelated.
Is it possible to insert graphic objects directly into the cells as if
they
would be characters ? I use Excel 2003 and I saw an Excel-Addin doing
this.
How can I do it by myself using VBA/DLL/... ?
Thousend thanks in advance!