close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()