Cells unlocked in a protected sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1770840%22%20slang%3D%22fr-FR%22%3ECells%20unlocked%20in%20a%20protected%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1770840%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CSPAN%3EHello%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EI'm%20trying%20to%20put%20in%20place%20the%20solution%20to%20have%20cells%20unlocked%20in%20a%20protected%20sheet%20and%20it%20doesn't%20really%20work.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EThis%20gives%20me%20after%20selecting%20a%20range%20of%202%20columns%2C%20only%20one%20cell%20unlocked.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EDoes%20anyone%20have%20a%20suggestion%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1770840%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1772236%22%20slang%3D%22de-DE%22%3ESubject%3A%20Cells%20unlocked%20in%20a%20protected%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1772236%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F828805%22%20target%3D%22_blank%22%3E%40gmmgmm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend.%20It%20can%20help%20us%20all%20if%20you%20upload%20an%20Excel%20file%20(without%20sensitive%20data)%2C%20no%20picture.%3C%2FP%3E%3CP%3EEven%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%3C%2FP%3E%3CP%3EYou%20could%20get%20a%20precise%20solution%20much%20faster%20with%20a%20file%20(w%2Fout%20sensitive%20data).%3C%2FP%3E%3CP%3EThis%20would%20also%20be%20a%20blessing%20for%20all%20of%20us%2C%20as%20we%20can%20understand%20the%20problem%20much%20better%2C%20a%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EThere%20are%20several%20ways%20you%20could%20do%20it%2C%20but%20you%20would%20have%20to%20see%20the%20file%20(without%20sensitive%20data).%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EThis%20way%20you%20can%20also%20rule%20out%20any%20file%20errors.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,
I’m trying to put in place the solution to have cells unlocked in a protected sheet and it doesn’t really work.
This gives me after selecting a range of 2 columns, only one cell unlocked.
Does anyone have a suggestion?

1 Reply

@gmmgmm 

 

With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture.

Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.

You could get a precise solution much faster with a file (w/out sensitive data).

This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.

There are several ways you could do it, but you would have to see the file (without sensitive data). This way you can also rule out any file errors.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)