解决excel保护的问题.docxVIP

在工具中找到宏，选择录制宏把名字随便改一下其他的不要改，然后 确定又到工具那去选择 停止宏又到工具那选择 宏单击编辑把里面的内容全部去掉把下面的代码复制到里面去代码是这些：Public Sub AllInternalPasswords() Breaks worksheet and workbook structure passwords. Bob McCormick probably originator of base code algorithm modified for coverage of workbook structure / windows passwords and for multiple passwords Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1.1) Modified 2003-Apr-04 by JEM: All msgs to constants, and eliminate one Exit Sub (Version 1.1.1) Reveals hashed passwords NOT original passwordsConst DBLSPACE As String = vbNewLine vbNewLineConst AUTHORS As String = DBLSPACE