View original (French)

Remove protection from an ODS sheet without a password

Solved
jacky40220 Posted messages 6 Status Member -  
jacky40220 Posted messages 6 Status Member -

Hello,

I protected an ODS sheet but without a password. How can I remove the protection from this sheet?

Thank you in advance. It's an address book and I wouldn't want to start over...


6 answers

  1.
    JCB40 Posted messages 3060 Registration date   Status Member Last intervention   479
     

    Hello

    To remove the protection, select Tools -> Protection and uncheck the
    Sheet

    0
  2. jacky40220 Posted messages 6 Status Member
     

    Hello!

    This is what I did, but a new window opened asking me to enter a password to remove the sheet protection, which doesn't exist, since it was marked as "optional." I didn't enter anything at all when I protected the sheet.

    Saint Francis of Assisi will have to go above and beyond because I've already tried a lot of things to get out of this deadlock.

    0
  3. JCB40 Posted messages 3060 Registration date   Status Member Last intervention   479
     

    If a password is requested, it's because there is one.

    0
  4. jacky40220 Posted messages 6 Status Member
     

    Okay! So, since I don't remember giving this password at all, how can I recover it?

    0
  6. yclik Posted messages 3875 Registration date   Status Member Last intervention   1 611
     

    Hello

    Is the sheet visible?

    If yes, copy the data and paste it into another workbook.

    0
  7. jacky40220 Posted messages 6 Status Member
     

    Hello!

    Indeed, the sheet is visible.

    I copied and pasted it into a new workbook where it is no longer protected.

    It lost its macro and I had to modify it to print it on a page, but in any case, my address book is functional.

    Thank you, have a great weekend, and best regards,

    0