Forum Discussion
Disable use of filters
Is it possible to disable the use of filters in Excel? I have a shared spreadsheet which has a number of hidden cells containing formulae. I want to disable to ability to use filters by other us...
A couple of random thoughts that occurred to me as I read your question. May or may not be applicable.
1. It sounds like you are "hiding" these cells or rows by using the Filter button, since you say that turning that off causes the rows to appear. It is also possible--altogether apart from the Filter button--to highlight a row and then hide it.
2. It also might be that separating the Input or data collection cells and areas from the Processing cells and areas -- in other words, a partial redesign of the way the spreadsheets are laid out, could resolve this. Mixing Input, Processing, and Output is, generally, not a good idea anyway; your situation is a good illustration of why that's the case.