View original (French)

Column lock

golda_3286 Posted messages 11 Registration date   Status Member Last intervention   -  
Raymond PENTIER Posted messages 58227 Registration date   Status Contributor Last intervention   -

Hello,

I have an Excel file that is shared and that I use as the basis for my work.

The problem is that those who have access make changes that affect the reliability of my data. I would like to lock all columns except column N. The idea is that I can modify the content of the locked columns by entering a password.

The goal is that a manager can only write in column N.

Thank you ++ for your help


2 answers

  1.
    PapyLuc51 Posted messages 4570 Registration date   Status Member Last intervention   1 513
     

    Hello,

    Unlock the cells in column N and protect the sheet with a password easy for you to remember.

    Only column N will be accessible to others.

    You will be able to make your changes by unlocking the sheet.

    Best regards

    1
  2. Raymond PENTIER Posted messages 58227 Registration date   Status Contributor Last intervention   17 490
     

    Hello Golda.

    So! didn’t work?

    Well, retirement is good! Especially in the Antilles...
    Raymond (INSA, AFPA)

    0