Sorting a worksheet with embedded documents in one column

J

JHQ

I need to sort a worksheet that has Word, Powerpoint and Mail Messages
embedded in one column and displayed as icons, using criteria in some of the
other columns. Attempting to do this seems to result in the embedded files
being redistributed on the worksheet. Is there a way to lock the embedded
files to the data in the rows so that the relationships are preserved after
sorting?
Any help greatly appreciated!
 
S

Sheeloo

Excel 2003
Right click on the object
Choose Format Objects|Properties
Select 'Don't move or size with cells'
 

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

Top