I have a spreadsheet containing 10 columns with specific data in each row. The spreadsheet will be protected except for one column where it is setup to allow a user to make comments. One of the columns contains the intials of employees as I want the user to beable to use the auto filter on this column allowing them to work on the records that pertain to them only. The problem when I protect the sheet the auto filter goes away. This is the case as well, when I don't protect this column. I was told to allow the user to use autofilter as this could be done by checking the appropriate box in the Protect Sheet dialog. When I go to the Protect Sheet menu I only have Object, Scenario and Contents as options. I have tried numerous combinations and have had no luck. Any suggestions would be greatly appreciated. Thank you
Marc
Marc