Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-324426%22%20slang%3D%22en-US%22%3EUsing%20the%20Find%20function%20will%20working%20on%20a%20protected%20worksheet%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-324426%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20a%20workbook%20in%20excel%20that%20gives%20updated%20information%20to%20my%20team.%26nbsp%3B%20I%20am%20the%20only%20one%20that%20is%20able%20to%20add%20info%20to%20certain%20sheets--those%20sheets%20are%20password%20protected.%26nbsp%3B%20How%20do%20I%20allow%20my%20team%20to%20use%20the%20Find%20function%20when%20these%20sheets%20are%20password%20protected.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20allowed%20my%20team%20the%20following%20when%20protecting%20the%20sheets%3A%3C%2FP%3E%3CP%3Eformat%20rows%3C%2FP%3E%3CP%3Esort%3C%2FP%3E%3CP%3Euse%20autofilter%3C%2FP%3E%3CP%3Eedit%20objects%3C%2FP%3E%3CP%3Eedit%20scenarios%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20else%20should%20I%20be%20checking%20off%3F%20Or%20should%20I%20uncheck%20a%20box%20that%20I%20have%20already%20checked%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-324426%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFind%20Function%20on%20Protected%20Sheets%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Lorigay
Occasional Visitor

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!!!

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies