Home

Adding Comments on a Protected Worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-691142%22%20slang%3D%22en-US%22%3EAdding%20Comments%20on%20a%20Protected%20Worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-691142%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20creating%20a%20form%20for%20someone%20where%20there%20are%20tabs%20for%20each%20employee%2C%20and%20am%20going%20to%20lock%20the%20cells%20that%20they%20don't%20need%20to%20add%20data.%20However%20when%20I%20protect%20the%20file%20I%20am%20not%20able%20to%20add%20a%20comment%20to%20specific%20cells.%20Which%20category%20do%20I%20need%20to%20check%20so%20someone%20can%20add%20a%20comment%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-691142%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EComments%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Elocked%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eprotect%20worksheet%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
EWillis
New Contributor

I am creating a form for someone where there are tabs for each employee, and am going to lock the cells that they don't need to add data. However when I protect the file I am not able to add a comment to specific cells. Which category do I need to check so someone can add a comment?

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies