I have a spreadsheet that is constantly updated and sent via email.
In this spreadsheet I have imported some objects (as icons) such as
mail messages and pics (screenshots) when I want to give more info
about an issue in a specified cell.
The problem is that the icons are not quot;gluedquot; to any specific cell, so
if I set a filter, the icons are everywhere.
Is it possible to quot;gluequot; this icons to a cell?--
ludahen
------------------------------------------------------------------------
ludahen's Profile: www.excelforum.com/member.php...oamp;userid=10392
View this thread: www.excelforum.com/showthread...hreadid=539836Untested...
Make sure that the icon is completely within the cell--no overlapping borders.
Right click on that object
choose format object
Properties tab|check move and size with cells
ludahen wrote:
gt;
gt; I have a spreadsheet that is constantly updated and sent via email.
gt; In this spreadsheet I have imported some objects (as icons) such as
gt; mail messages and pics (screenshots) when I want to give more info
gt; about an issue in a specified cell.
gt; The problem is that the icons are not quot;gluedquot; to any specific cell, so
gt; if I set a filter, the icons are everywhere.
gt; Is it possible to quot;gluequot; this icons to a cell?
gt;
gt; --
gt; ludahen
gt; ------------------------------------------------------------------------
gt; ludahen's Profile: www.excelforum.com/member.php...oamp;userid=10392
gt; View this thread: www.excelforum.com/showthread...hreadid=539836
--
Dave Peterson
Dave Peterson Wrote:
gt; Untested...
gt;
gt; Make sure that the icon is completely within the cell--no overlapping
gt; borders.
gt;
gt; Right click on that object
gt; choose format object
gt; Properties tab|check move and size with cells
gt;
gt;
gt;
gt; ludahen wrote:
gt; gt;
gt; gt; I have a spreadsheet that is constantly updated and sent via email.
gt; gt; In this spreadsheet I have imported some objects (as icons) such as
gt; gt; mail messages and pics (screenshots) when I want to give more info
gt; gt; about an issue in a specified cell.
gt; gt; The problem is that the icons are not quot;gluedquot; to any specific cell,
gt; so
gt; gt; if I set a filter, the icons are everywhere.
gt; gt; Is it possible to quot;gluequot; this icons to a cell?
gt; gt;
gt; gt; --
gt; gt; ludahen
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; ludahen's Profile:
gt; www.excelforum.com/member.php...oamp;userid=10392
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=539836
gt;
gt; --
gt;
gt; Dave Peterson
Thanks Dave, this did the trick--
ludahen
------------------------------------------------------------------------
ludahen's Profile: www.excelforum.com/member.php...oamp;userid=10392
View this thread: www.excelforum.com/showthread...hreadid=539836
- Oct 05 Fri 2007 20:39
How to quot;Gluequot; an object icon to a cell?
close
全站熱搜
留言列表
發表留言