View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dreiding Dreiding is offline
external usenet poster
 
Posts: 80
Default Objects, Cell Referencing and Sorting

This is an extension of another question I posted on Scrollbars. I am using
Excel 2003. Here's the situation I need help on.
I have table with a scrollbar in each cell of a column. Each scrollbar is
linked to the cell under the object. My problem when I sort my table, the
scrollbar cell reference is updated to sorted location of the cell. I need it
to remain fixed.

How do I fix the scrollbar cell reference to be the cell beneath it with no
impact due to sorting?

Thanks,
- Pat