I have a large spreadsheet that will be saved to a shared network for multiple users to access and update. I have 3 things that I would like the spreadsheet to do, that I cannot figure out how to get them ALL to work at the same time.

1. The spreadsheet must in in Shared mode to allow multiple users to edit at the same time.
2. I also added some simple code to reset the auto-filters each time the spreadsheet is opened. The users of the spreadsheet are not advanced Excel users in many cases. Each user would be instructed to filter the spreadsheet to only show their items, and then to make the changes to those assigned to them. Obviously, they wouldn't likely clear the filter before saving, and the next person opening the file could be confused.
3. Finally, I would like to protect the sheet so that only the 2 input columns where the users are being asked to make their changes, would be unlocked, protecting the rest of the document from being changed/deleted.

I can get #1 and #2 to work together, but when I try and add the protection, the autofilter clear code doesn't work. My guess is that the macro won't clear a filter on a column that is read-only.

Is there a code that would allow me to clear the autofilters, and then apply the protection to the worksheet?

Thanks for your patience in advance. I'm very new to VB and macros.

Amanda