Using the Find function will working on a protected worksheet in Excel

Copper Contributor

Have a workbook in excel that gives updated information to my team.  I am the only one that is able to add info to certain sheets--those sheets are password protected.  How do I allow my team to use the Find function when these sheets are password protected.  

I have allowed my team the following when protecting the sheets:

format rows

sort

use autofilter

edit objects

edit scenarios

 

What else should I be checking off? Or should I uncheck a box that I have already checked?

 

Thank you!!!

 

 

0 Replies