View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Sorting a worksheet with embedded documents in one column

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


"JHQ" wrote:

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!
--
John