[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Re: OleObject really embedded in cell - not as shape overlay

Jon Peltier

12/15/2006 2:15:00 PM

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://Pelti...
_______


"Ray Men" <Ray Men@discussions.microsoft.com> wrote in message
news:A03645F6-FD98-4B86-A2D8-43992EBC2956@microsoft.com...
>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!