View original (French)

Column lock

golda_3286 Posted messages 11 Registration date   Status Member Last intervention   -  
PapyLuc51 Posted messages 4579 Registration date   Status Member 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


4 answers

  1.
    PapyLuc51 Posted messages 4579 Registration date   Status Member Last intervention   1 515
     

    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 58230 Registration date   Status Contributor Last intervention   17 496
     

    Hello Golda.

    So! didn’t work?

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

    0
  3. PapyLuc51 Posted messages 4579 Registration date   Status Member Last intervention   1 515
     

    Hello

    Greetings to Raymond.

    @golda_3286 StatusMember We would really like your response on the subject

    Best regards

    0
  4. Nain_Porte_Quoi Posted messages 178 Registration date   Status Member Last intervention   40
     

    Hello,

    perhaps, and I mean perhaps, that if notifications were working we would have "perhaps" a reply, but none are functioning

    0
    1. PapyLuc51 Posted messages 4579 Registration date   Status Member Last intervention   1 515
       

      Greetings,

      .

      Personally, following my question about notifications, I have disabled everything except private messages.

      I just check if a followed discussion is bold in the right-hand column and that suits me very well.

      .

      Sincerely

      0