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