Home

excel ne verrouille que certaines cellules

%3CLINGO-SUB%20id%3D%22lingo-sub-792565%22%20slang%3D%22fr-FR%22%3Eexcel%20only%20locks%20certain%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-792565%22%20slang%3D%22fr-FR%22%3EHello%2C%20When%20I%20use%20the%20function%20protect%20the%20sheet.%20my%20cell%20sizes%20are%20well%20locked%2C%20however%20some%20cells%20remain%20modifiable.%20Does%20anyone%20know%20if%20it's%20a%20setting%20problem%20or%20excel%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-792565%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-792595%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20ne%20verrouille%20que%20certaines%20cellules%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-792595%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F387872%22%20target%3D%22_blank%22%3E%40GGabds35%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20believe%20it's%20a%20setting%20in%20Format%20Cells%2C%20Protection%2C%20before%20Protect%20Sheet%20is%20applied.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-792621%22%20slang%3D%22fr-FR%22%3ERe%3A%20excel%20only%20locks%20certain%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-792621%22%20slang%3D%22fr-FR%22%3Eyes%20it%20works%20from%20line%201%20to%2015%2C%20but%20not%20then%20...%3C%2FLINGO-BODY%3E
GGabds35
New Contributor
Bonjour, Quand j’utilise la fonction protéger la feuille. mes formats de cellules sont bien verrouillés, cependant certaines cellules restent modifiables. Quelqu'un sait-il si c'est un problème de paramétrage ou excel?
2 Replies

@GGabds35 

I believe it's a setting in Format Cells, Protection, before Protect Sheet is applied. 

oui ça fonctionne de la ligne 1 a 15, mais pas ensuite...
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies