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?