Icon for inserted file object doesn't collapse away when closeoutline group
 

I'm using Excel 2003 on Windows XP. I created a table with some
outline groups (grouped up by row). I also embedded some Word and
email (msg) files into some of the cells using Insert-Object-
CreateFromFile, unchecked "Link to file", and checked "Display as
icon". When I collapse a group, the icons for the embedded files
still linger, disembodied-like. Is there a way to make them go away
like the rest of the grouped rows when the group is collapsed?

Thx.

Icon for inserted file object doesn't collapse away when closeoutline group
 

Make sure the icon is completely within the cell (or row).

Then rightclick on the icon
Format Object|Properties tab|check "move and size with cells"

Paul wrote:

I'm using Excel 2003 on Windows XP. I created a table with some
outline groups (grouped up by row). I also embedded some Word and
email (msg) files into some of the cells using Insert-Object-
CreateFromFile, unchecked "Link to file", and checked "Display as
icon". When I collapse a group, the icons for the embedded files
still linger, disembodied-like. Is there a way to make them go away
like the rest of the grouped rows when the group is collapsed?

Thx.

--

Dave Peterson

Icon for inserted file object doesn't collapse away when closeoutline group
 

Works like a charm. Thx.

On Mar 31, 4:03 pm, Dave Peterson wrote:
Make sure the icon is completely within the cell (or row).

Then rightclick on the icon
Format Object|Properties tab|check "move and size with cells"

Paul wrote:

I'm using Excel 2003 on Windows XP. I created a table with some
outline groups (grouped up by row). I also embedded some Word and
email (msg) files into some of the cells using Insert-Object-
CreateFromFile, unchecked "Link to file", and checked "Display as
icon". When I collapse a group, the icons for the embedded files
still linger, disembodied-like. Is there a way to make them go away
like the rest of the grouped rows when the group is collapsed?

Thx.