Autofilter & Protection

  • Thread starter Thread starter Ukmopar
  • Start date Start date
U

Ukmopar

Hi,

I use autofilter to filter out rows with results that are
zero. When I protect the sheet to stop the formulae being
changed, autofilter is no longer available. I've tried
excluding the column where the filter works from the
locked area. No joy.

Does anyone have any suggestions please.

Thanks
 
Back
Top