Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OleObject really embedded in cell - not as shape overlay
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Embedded OleObject displayed as icon | Excel Programming | |||
How to overlay text boxes over embedded Autocad dwg | Excel Discussion (Misc queries) | |||
Trying to get/set contents of embedded file using Excel OleObject | Excel Programming | |||
Reference oleobject within shape group | Excel Programming | |||
Deleting a shape and the cell contents the shape is in. | Excel Programming |