Use Excel AutoFilter on protected cells?

[WaltW]

I have an Excel worksheet that is used by several people as a data-entry sheet. Because of the need to preserve the format of the columns, cells, etc, some of the columns on the data-entry sheet are protected. A problem that has arisen is that once any cells are protected, the AutoFilter function is no longer available (it's grayed out). Isn't there some way I can allow the data-entry folks to use AutoFilter without sacrificing the protection of the format? Any help would be greatly appreciated.

Thanks!

Walt Wright

 

[pauldes]

What version? In Excel XP you have the option to "Allow users of this worksheet to:" and then select from several options that they are allowed to perform, including SORT and USE AUTOFILTER. Thes options are available when you choose Tools>Protection>Protect Sheet.

 

[WaltW]

Sorry. I'm using Excel 2000, which doesn't have the options you mention.

Walt