How to "Glue" an object icon to a cell?
 

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 "glued" to any specific cell, so
if I set a filter, the icons are everywhere.
Is it possible to "glue" this icons to a cell?


--
ludahen
------------------------------------------------------------------------
ludahen's Profile: http://www.excelforum.com/member.php...o&userid=10392
View this thread: http://www.excelforum.com/showthread...hreadid=539836

How to "Glue" an object icon to a cell?
 

Untested...

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:

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 "glued" to any specific cell, so
if I set a filter, the icons are everywhere.
Is it possible to "glue" this icons to a cell?

--
ludahen
------------------------------------------------------------------------
ludahen's Profile: http://www.excelforum.com/member.php...o&userid=10392
View this thread: http://www.excelforum.com/showthread...hreadid=539836

--

Dave Peterson

How to "Glue" an object icon to a cell?
 

Dave Peterson Wrote:
Untested...

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:

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 "glued" to any specific cell,
so
if I set a filter, the icons are everywhere.
Is it possible to "glue" this icons to a cell?

--
ludahen

------------------------------------------------------------------------
ludahen's Profile:
http://www.excelforum.com/member.php...o&userid=10392
View this thread:
http://www.excelforum.com/showthread...hreadid=539836

--

Dave Peterson

Thanks Dave, this did the trick


--
ludahen
------------------------------------------------------------------------
ludahen's Profile: http://www.excelforum.com/member.php...o&userid=10392
View this thread: http://www.excelforum.com/showthread...hreadid=539836