Ps. I used the Auto_open subroutine.

If you reset the filter when they were closing the workbook, then you'd have to
save it in that state. And if the user opened the workbook and did a lot of
damage and wanted to close without saving, your code that did the save could
really make you sad.

George wrote:

On my spread sheet I am using the Auto Filter and it works ok. My problem is
the spread sheet is shared on a LAN my all the office personnel use it and no
one ever puts all the columns back to the sort "All" default. Is there a way
to make the spread sheet when its closed reset all columns to the "All"
default so the next person doesn't have to make all the corrections to return
the sheet to it's normal view.

Thanks - George

--

Dave Peterson