Auto Filter

[mjmoon]

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

 

[Oaktree]

The option to allow users to use autofilter when protecting a sheet is only available in Excel 2002 or later. It sounds like you're using Excel 2000.

As such, try Andrew's code here instead:

http://www.mrexcel.com/board2/viewtopic.php?t=159160