SOLVED
Home

sélectionner les cellules verrouillées sans pouvoir les modifier

%3CLINGO-SUB%20id%3D%22lingo-sub-789719%22%20slang%3D%22fr-FR%22%3ESelect%20locked%20cells%20without%20being%20able%20to%20change%20them%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-789719%22%20slang%3D%22fr-FR%22%3EHello%2C%20I%20want%20to%20copy%20locked%20cells%20from%20a%20protected%20sheet.%20I%20do%20this%20by%20checking%20the%20%22select%20locked%20cells%22%20box%20in%20protecting%20the%20sheet.%20The%20problem%20is%20that%20it%20unlocks%20the%20cell%2C%20and%20therefore%20allows%20the%20modification%2C%20which%20is%20not%20my%20goal.%20Does%20anyone%20have%20a%20solution%3F%20Ga%C3%ABtan%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-789719%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-789787%22%20slang%3D%22en-US%22%3ERe%3A%20s%C3%A9lectionner%20les%20cellules%20verrouill%C3%A9es%20sans%20pouvoir%20les%20modifier%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-789787%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%3EHi%3C%2FP%3E%3CP%3EPlease%20note%20that%3A%3C%2FP%3E%3COL%3E%3CLI%3EBy%20default%2C%20the%2017179869184%20cells%20in%20any%20worksheet%20are%20locked%20(unless%20you%20change%20this%20default%20on%20the%20Protection%20Tab%20of%20the%20Format%20Cell%20dialog%20Box)%3C%2FLI%3E%3CLI%3EWhen%20applying%20protection%20on%20the%20Review%20Tab%20and%20Click%20on%20Protect%20Sheet%20%26gt%3B%26gt%3B%20The%20box%20for%20%22Select%20Locked%20Cells%22%20is%20Checked%20by%20default.%3C%2FLI%3E%3CLI%3EApplying%20the%20protection%20does%20not%20prevent%20copying%20cell%20contents%20but%20should%20NOT%20Unlock%20or%20UnProtect%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBased%20upon%20these%20%3CSTRONG%3Efacts%3C%2FSTRONG%3E%2C%20review%20the%20above%20default%20settings%20specially%20in%20the%20Format%20cell%20Dialog%20bo%2C%20may%20be%20what%20you%20assume%20s%20Locked%2C%20has%20been%20Unlocked%20on%20any%20occasion.%3C%2FP%3E%3CP%3EGood%20Luck%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-789884%22%20slang%3D%22fr-FR%22%3ERe%3A%20Select%20locked%20cells%20without%20being%20able%20to%20change%20them%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-789884%22%20slang%3D%22fr-FR%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365248%22%20target%3D%22_blank%22%3E%40nabilmourad%3C%2FA%3EThank%20you.%20it%20works%20in%20part...%20indeed%2C%20some%20cells%20remain%20modifiable%20when%20they%20are%20supposed%20to%20be%20locked...%20Ga%C3%ABtan%3C%2FLINGO-BODY%3E
GGabds35
New Contributor
Bonjour, Je souhaite copier des cellules verrouillées à partir d'une feuille protégée. J'y arrive en cochant la case "sélectionner les cellules verrouillées" dans protéger la feuille. Le problème, c'est que ça déverrouille la cellule, et permet donc la modification, ce qui n'est pas mon objectif. Quelqu'un a-t-il une solution? Gaëtan
2 Replies
Solution

@GGabds35 

Hi

Please note that:

  1. By default, the 17179869184 cells in any worksheet are locked (unless you change this default on the Protection Tab of the Format Cell dialog Box)
  2. When applying protection on the Review Tab and Click on Protect Sheet >> The box for "Select Locked Cells" is Checked by default.
  3. Applying the protection does not prevent copying cell contents but should NOT Unlock or UnProtect

 

Based upon these facts, review the above default settings specially in the Format cell Dialog bo, may be what you assume s Locked, has been Unlocked on any occasion.

Good Luck

Nabil Mourad

@nabilmourad Merci. ça fonctionne en parti... en effet, certaines cellules restent modifiables alors qu'elles sont censées être verrouillées... Gaëtan
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies