Hi,

I have a file that is located on a network drive. The file tracks the status of parts. There file is large with many rows and columns.

The file has an AutoFilter that sorts each column the users want. Many times it is difficult to find which column is active. I figured I could come up with a Macro that removed the Autofilter to show all rows and then setup the Autofilter again. Then sorted it by the first column which is the number the file should be by default so the locations of parts don't move around.

I am not very experienced at setting up Macros in Excel. I did do a little bit of VB like 4 years back in school, but I barely can remember it right now.

The problems:
The file is shared and it won't let me add the macro.
The file is on a network drive, and reading online that is another issue.