LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,582
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Embedded OleObject displayed as icon eedev Excel Programming 4 February 24th 10 11:48 AM
How to overlay text boxes over embedded Autocad dwg Diana Excel Discussion (Misc queries) 0 May 25th 09 05:35 PM
Trying to get/set contents of embedded file using Excel OleObject Rich[_22_] Excel Programming 1 April 15th 04 07:21 AM
Reference oleobject within shape group Andrew[_16_] Excel Programming 4 December 24th 03 02:31 AM
Deleting a shape and the cell contents the shape is in. Tom Ogilvy Excel Programming 0 October 9th 03 03:43 AM


All times are GMT +1. The time now is 02:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"