Comment supprimer la protection d’une feuille de classeur Excel sans connaitre le mot de passe ?

Si vous avez décidé de protéger le contenu d’une feuille de classeur Excel par un mot de passe et que manque de chance, vous ne vous souvenez pas de ce fameux mot de passe, il existe une solution!


Il faut savoir que ; lorsque vous mettez un mot de passe sur une feuille de classeur Excel (pour vérouiller l’accès à certaines cellules par exemple), le logiciel ne mémorise pas le mot de passe mais une clé sur 15 bits calculée à partir de ce mot de passe.

Il y a donc des milliards de mots de passe qui ont une clé équivalente puisqu’il y a seulement 2^15 possiblités de clés (32 768 possibilités).

On peut protéger une feuille avec un mot de passe et la déprotéger avec un équivalent, reprotéger avec un autre équivalent etc…

Place au test, il vous suffit d’insérer le code dans un module et d’exécuter la macro en faisant ALT+F8 ou en affectant la macro à un bouton :


Sub supprimer_protection()

Dim a, b, c, d, e, f, g, h, i, j, k, l As Integer

On Error Resume Next
For a = 65 To 66
For b = 65 To 66
For c = 65 To 66
For d = 65 To 66
For e = 65 To 66
For f = 65 To 66
For g = 65 To 66
For h = 65 To 66
For i = 65 To 66
For j = 65 To 66
For k = 65 To 66
For l = 32 To 126
ActiveSheet.Unprotect Chr(a) & Chr(b) & Chr(c) & _
Chr(d) & Chr(e) & Chr(f) & Chr(g) & Chr(h) & _
Chr(i) & Chr(j) & Chr(k) & Chr(l)
If ActiveSheet.ProtectContents = False Then
MsgBox "La Protection a été enlevée – Un mot de passe satisfaisant est :" & Chr(a) & Chr(b) & _
Chr(c) & Chr(d) & Chr(e) & Chr(f) & Chr(g) & _
Chr(h) & Chr(i) & Chr(j) & Chr(k) & Chr(l)
Exit Sub
End If

End Sub


Bien sur, vous pouvez aussi utiliser cette méthode pour accéder aux données d’un fichier qu’un collègue aurait un tout petit peu trop protégé 🙂

34 Comments Comment supprimer la protection d’une feuille de classeur Excel sans connaitre le mot de passe ?

  1. Kacey

    Yesterday, while I was at work, my cousin stole my iPad and tested
    to see if it can survive a twenty five foot drop, just so
    she can be a youtube sensation. My apple ipad is now broken and she has 83 views.
    I know this is entirely off topic but I had to share it
    with someone!


    I like the valuable info you provide in youyr articles.
    I will booimark your blog and check again here regularly.
    I’m quite sure I’ll llearn a llot of new stuff right here!
    Best of luck for the next!


    Hello there! Quick question that’s totally off topic.
    Do you know how to make your site mobile friendly? My weblog looks weird when browsing from my iphone
    4. I’m trying to find a theme or plugin that might be able to resolve this problem.
    If you have any suggestions, please share.
    With thanks!

    My page … pusyy888 (

  4. Arnoldo

    It is the best time to make some plans for the future and it is time
    to be happy. I have read this post and if I could I desire to suggest you some interesting things or tips.
    Maybe you could write next articles referring to this article.
    I want to read even more things about it!

  5. Aundrea

    Hey there are using WordPress for your blog platform?
    I’m new to the blog world but I’m trying to get started and set up my own. Do you require any coding
    expertise to make your own blog? Any help would be really appreciated!

  6. Johnie

    Somebody essentially help to make seriously posts I would state.
    This is the first time I fdequented your web page and thus
    far? I surprised with the research you made to create this
    particular publish extraordinary. Fantastic job!

  7. jasa backlink pbn

    Do yоu have a spam problem on tһis Ƅlog; I also am a blogger, and I was wondering your ѕituation; many oof us have developed
    some nicе methods and we are lookіng tօ trade strategies with other folks, bbe sure to shoot me
    an e-mail if interested.

  8. Jeremy

    Please let me know if you’re looking for a writer for your weblog.
    You have some really good articles and I believe I would be a good asset.
    If you ever want to take some of the load off, I’d really like to write some articles for
    your blog in exchange for a link back to mine. Please blast
    me an email if interested. Thank you!

  9. Carroll

    Magnificent website. Lots of useful information here.
    I’m sending it to a few pals ans also sharing in delicious.

    And certainly, thanks in your effort!

  10. Helena

    Can I simply say what a relief to uncover someone who actually understands
    what they are talking about on the internet. You certainly know how to bring
    a problem to light and make it important. More
    people need to read this and understand this side of
    your story. I was surprised that you are not more popular since you definitely
    possess the gift.

    my website: cara masuk id test club suncity (Helena)

  11. mod apk gratis

    I’m not sure exactly why but this weblog is loading extremely slow for me.
    Is anyone else having this issue or is it a problem on my end?
    I’ll check back later and see if the problem still exists.

  12. Reva

    I have been surfing online more than 4 hours today, yet I never found any
    interesting article like yours. It’s pretty worth enough for me.
    In my view, if all site owners and bloggers made good content as you did, the internet will be a lot more useful than ever before.

    Here is my blog post – download game king855 (Reva)


    Great items from you, man. I have be aware your stuff previous to and you
    are simply extremely great. I really like what you’ve received right
    here, really like what you’re saying and the way wherein you
    are saying it. You are making it enjoyable and you continue
    to care for to stay it sensible. I can not wait to read far more from you.
    That is actually a great web site.

  14. Pam

    First off I want to say wonderful blog! I had a quick question which I’d like to ask if you
    don’t mind. I was curious to know how you center yourself and clear your mind before writing.
    I’ve had difficulty clearing my mind in getting my ideas out.

    I do take pleasure in writing but it just seems like the first 10
    to 15 minutes are generally lost simply just trying to figure out how to begin. Any recommendations or tips?
    Thank you!


Leave a Reply

Your email address will not be published.