ExcelBanter - protect cell ranges in spreadsheet and have data filters on

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - protect cell ranges in spreadsheet and have data filters on (https://www.excelbanter.com/excel-discussion-misc-queries/108610-protect-cell-ranges-spreadsheet-have-data-filters.html)

prizm

protect cell ranges in spreadsheet and have data filters on

I have a need to protect cell ranges in a spreadsheet and have data filters
on and working. I am unable to both protect the worksheet with selected
unlocked cells and have data filters working. Got any suggestions?

All times are GMT +1. The time now is 08:35 AM.