Probably easier to remove the sort icons from the toolbar - that way
the user will have to use Data | Sort where there is a bit more
intelligence programmed in.

Hope this helps.

Pete

On Feb 6, 7:25 pm, pilgrim wrote:
Is there a way to lock the columns together so someone else does not missort
the worksheet?



"Mike" wrote:
select all the columns and then sort on the date column and the association
will be retained

"pilgrim" wrote:

Hi All, I have a worksheet that has several columns, one with dates.
I would like to sort the rows by that date column. When I click the column
and sort it sorts only that column. I would like all rows to stay associated
with there original rows (more like a database would) Any help please.
Thanks, ED- Hide quoted text -

- Show quoted text -