Data Protection | How can I let users sort but not touch?

Published: Fri, 08/15/14


The Excel Expert
Learn to love Excel - one cell at a time. Tutorials for beginners, tips for experienced users


Data Protection | How can I let users sort but not touch?- 2014-08-11 05:38:09-04

Not so long ago I was asked by a user for help with her file. She wanted people to be able to sort and filter but not do ANYTHING else with it. Of course I went to try my usual things of setting up protection Review – Protect Sheet – tick Sort, tick Autofilter. Much [...]
Read more...