For auto filter: put it in before protection. When they want to remove the
multiple parameters they can choose "all" from each drop down where
parameters have been set.
--
JNW


"PAR" wrote:

I would like to password protect a worksheet for cell contents, but allow for
any other manipulation of the file using any of the other functions - except
deleting. I tried suggesting read only - although I told the team members
they do not need the password to use the file, they do not grasp the concept.
Next I tried to protect the worksheet and allow filtering, inserting columns
& rows, - everything but changing contents and deleting, but the menu
functionally will not work. Example = auto filter. When protected one can
not create the filter, it has to be put in place before protecting. Then
when the filter is used, one can not choose to turn off the auto filter to
get rid of multiple filters. Is there a VB script that will do what I want?
If so, how do I apply it?