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?

谢谢大家！

我注意到我发布的示例代码中的 For n = 32 To 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 密码.

• 这篇文章的一个完整例子是这里(下面的截图)
• 谷歌搜索 excel 表格保护test"和zzyw" 提供了其他参考资料，例如 来自 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

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