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

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

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
Click to expand...
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.
 
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"
 
Works like a charm. Thx.

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"
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Collapsing groups in Macro 7
Excel 2003- Expand & Collapse Groups recalc/performace problem 1
Unable to open embedded word document from Excel 0
Outline View: collapse 'up' to parent heading? 7
Change label of an embedded-object icon 2
Inserting Rows with tabs grouped 2
Nested grouping of hierarchical headings during/after import 1
Change label text on an inserted object displayed as icon 1

Back
Top