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
Highlighted
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
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies
INDEX & MATCH interrupted by Inconsistent Dates
shade206 in Excel on
18 Replies
!SPILL error with SUMIFS formula
Dzung Vu in Excel on
18 Replies
Need to extract values from named cells (Get and Transform)
JEMagnussen in Excel on
23 Replies