admin管理员组文章数量:1540636
2024年5月15日发(作者:)
excel表设置密码忘记如何打开
在Excel中录入过多的重要数据是人们的习惯,因此这些文件都需要利用密码进行保
护。但是忘记密码了怎么办呢,下面让小编为你带来excel表设置密码忘记如何打开的解
决方法。
excel表设置密码忘记打开步骤:
1. 打开需要破解密码的Excel
2. 按Alt+F11进入VBA编辑界面
3. 插入 -- 模块(Module)
4. 在右边Module的空白编辑区域,复制粘贴下面所有内容
5. F5,运行该VBA命令
---------------------(下面的内容在第四步复制进去)-------------------------
Option Explicit
Public Sub AllInternalPasswords()
Breaks worksheet and workbook structure passwords. Bob McCormick
第 1 页 共 11 页
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 passwords
Const DBLSPACE As String = vbNewLine vbNewLine Adapted from Bob
McCormick base code by Norman Harker and JE McGimpsey
Const HEADER As String = AllInternalPasswords User Message
Const VERSION As String = DBLSPACE Version 1.1.1 2003-Apr-04
Const REPBACK As String = DBLSPACE Please report failure to the
mming newsgroup.
Const ALLCLEAR As String = DBLSPACE The workbook should now be free of
all password protection, so make sure you: SAVE IT NOW! and also BACKUP!,
BACKUP!!, BACKUP!!! Also, remember that the password was put there for a
reason. Dont stuff up crucial formulas or data. Access and use of some data
第 2 页 共 11 页
版权声明:本文标题:excel表设置密码忘记如何打开 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://m.elefans.com/xitong/1715719289a466702.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论