Locking the sheets within a spread sheet to prevent moving

%3CLINGO-SUB%20id%3D%22lingo-sub-1625533%22%20slang%3D%22en-US%22%3ELocking%20the%20sheets%20within%20a%20spread%20sheet%20to%20prevent%20moving%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1625533%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20figure%20out%20how%20to%20lock%20the%20sheets%20within%20the%20spreadsheet%20to%20prevent%20them%20from%20moving%20around%20whenever%20someone%20clicks%20on%20them.%20Is%20there%20a%20way%20to%20do%20that%20without%20locking%20the%20whole%20spreadsheet%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1625533%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1625570%22%20slang%3D%22en-US%22%3ERE%3A%20Locking%20the%20sheets%20within%20a%20spread%20sheet%20to%20prevent%20moving%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1625570%22%20slang%3D%22en-US%22%3EAt%20first%20sight%2C%20'Protect%20Workbook'%20would%20appear%20to%20do%20what%20you%20require.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1625592%22%20slang%3D%22en-US%22%3ERE%3A%20Locking%20the%20sheets%20within%20a%20spread%20sheet%20to%20prevent%20moving%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1625592%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214174%22%20target%3D%22_blank%22%3E%40Peter%20Bartholomew%3C%2FA%3E%20I%20saw%20that%2C%20but%20it%20wasn't%20clear%20if%20the%20workbook%20is%20still%20able%20to%20be%20used%20the%20same%20way.%20Do%20you%20know%20if%20you%20are%20still%20able%20to%20work%20in%20the%20%22live%22%20version%20of%20the%20workbook%2C%20if%20the%20sheets%20are%20locked%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1625616%22%20slang%3D%22en-US%22%3ERE%3A%20Locking%20the%20sheets%20within%20a%20spread%20sheet%20to%20prevent%20moving%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1625616%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F778337%22%20target%3D%22_blank%22%3E%40melanieadams%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20far%20as%20I%20know%2C%20formulas%20and%20data%20may%20still%20be%20changed%20without%20hinderance.%26nbsp%3B%20Just%20do%20it%20and%20try%3B%20don't%20forget%20the%20password%20though!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1625750%22%20slang%3D%22en-US%22%3ERe%3A%20Locking%20the%20sheets%20within%20a%20spread%20sheet%20to%20prevent%20moving%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1625750%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F778337%22%20target%3D%22_blank%22%3E%40melanieadams%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20mean%20structure%20protection%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20517px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F215866i7F3C5E103FA28292%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I am trying to figure out how to lock the sheets within the spreadsheet to prevent them from moving around whenever someone clicks on them. Is there a way to do that without locking the whole spreadsheet

4 Replies
Highlighted
At first sight, 'Protect Workbook' would appear to do what you require.
Highlighted

 @Peter Bartholomew I saw that, but it wasn't clear if the workbook is still able to be used the same way. Do you know if you are still able to work in the "live" version of the workbook, if the sheets are locked?

@melanieadams 

As far as I know, formulas and data may still be changed without hinderance.  Just do it and try; don't forget the password though!

Highlighted

@melanieadams 

Perhaps you mean structure protection

image.png