Filtering Withing a Protected Worksheet

[Guest]

Does anyone know of a way in which I can enable filtering within a protected worksheet. I have a huge spreadsheet I want to send out to the field but I want to limit the fields that they can modify, but yet I want them to be able to filter the data for easy input of the data.

Really appreciate any suggestions you might have.

 

[Frank Kabel]

Hi
if you have Excel 2002 you can check this option in the protection
dialog

 

[Debra Dalgleish]

There are instructions on my web site for filtering on a protected
worksheet:

http://www.contextures.com/xlautofilter03.html#Protect