brillocream
New Member
- Joined
- Oct 7, 2015
- Messages
- 1
Hi everyone,
I am trying to figure out how to lock auto-filter settings because I am trying to figure out how to get a work sheet to only display rows with certain values. There may be a better way to do this, but this was the first thing I thought of. Basically user A can only see rows with value X in column 3. Rows with all other values must be hidden and they cannot be able to reveal them.
Thoughts?
I am trying to figure out how to lock auto-filter settings because I am trying to figure out how to get a work sheet to only display rows with certain values. There may be a better way to do this, but this was the first thing I thought of. Basically user A can only see rows with value X in column 3. Rows with all other values must be hidden and they cannot be able to reveal them.
Thoughts?
