View original (French)

Remove protection from an ODS sheet without a password

Solved
jacky40220 -  

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

    Hello

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

    1. jacky40220 Author

      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.

      2. jacky40220 Author

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

        2.  yclik

          Hello

          Is the sheet visible?

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

          1. jacky40220 Author

            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,