It might be easier to copy your data to another range to do the sorting and
then paste it back into the table. You would have to work with values only.
That would leave the scroll bars intact. This assumes that there are no
formulas in the applicable range.

"Dreiding" wrote:

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