Hi,

would appreciate some help with this please. I have a detailed spreadsheet with a autofilter so people can choose which lines to update. I want to protect the worksheet and my formulas from any of the users changing them. Only when I apply the protection the autofilter stops working? Any suggestions around it?

I have tried unlocking the cells which contain the filters before protecting the worksheet, but still doesn't work. Is there a way around this?
regards
R