Excel的工作表密码保护如何工作 [英] How does Excel's worksheet password protection work

问题描述

这段代码已经在网络上浮动了好几年 - 显然可以提供密码来解密你不知道密码的excel电子表格。

This code has been floating around the net for quite a few years - it's apparently able to provide a password for decrypting an excel spreadsheet that you don't know the password to.

http://www.theofficeexperts.com/VBASamples/Excel02.htm

我对这是如何工作感兴趣，但我似乎无法做到这一点。我假设它是以一定的价值加密的，可以通过多种方式获得（网上的几个地方说它会给你原始密码或另一个可以工作的），像公钥一样 - 您可以拥有100个公钥，所有这些都可以使用一个私人密钥。

I'm interested in how this works but I don't seem to be able to work it out. I'm assuming it's encrypted under a certain value that can be gotten to in a number of ways (a few places on the net say it'll give you the original password or another one that will work) sort of like a public key - you can have 100 public keys that all work with a single private one.

对我来说，它似乎是创建整数变量，并填写一个特定的数字，数字进入相关字符。这些总是不一样吗？如果是这样，Excel保护是否有主密码？

To me it seems like it's creating integer variables and filling them with a specific number, before turning that number into the relevant characters. Wouldn't these always be the same? If so, is there "master password" for Excel protection?

感谢所有！

编辑：在我发布的示例代码中注意到了对于n = 32到126 。使用ASCII表进行交叉引用，这似乎是从空格到波浪号的所有字符。这是一种类型的字典攻击我不明白由于语法？

I've noticed the For n = 32 To 126 in the example code I posted. Cross referencing with an ASCII table that seems to be all characters from space through to tilde. Is this some sort of dictionary attack I'm not understanding due to syntax?

推荐答案

这是一个小世界，作为代码表示我在10年前的另一个论坛上发布了该代码，在其他地方看到过该代码 - 我认为 John Walkenbach的旧网站

It is a small world, as the code indicates I posted that code at another forum around 10 years ago having seen it somewhere else - I think on John Walkenbach's old web site

请注意，此代码保护仅适用于工作表保护 - 不适用于Excel的文件打开或VBA密码。

• 这个写作的一个例子是这里（下面的截图）


• googling excel sheet protectiontestandzzyw提供其他参考，如来自Tom Urtis

• One example of this write-up in full is here (screenshot below)
• googling excel sheet protection "test" and "zzyw" gives other references such as this from Tom Urtis

< img src =https://i.stack.imgur.com/9jVpa.pngalt =在此输入图像说明>

这篇关于Excel的工作表密码保护如何工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！