破解excel受保护文件（Cracking excel protected files）.docVIP

破解excel受保护文件（Cracking excel protected files） Excel - undo the password for the worksheet protection password and get the original password In daily work, if you encounter such a situation: you use Excel statements, forms, procedures, the formula, function settings in the cell, in order to prevent others from modifying your settings or prevent you inadvertently modify, you may use the Excel worksheet protection function, but the time for a long time to protect the password easy to forget how to do this? Sometimes you download small programs in Excel format from the Internet, you want to modify, but the author added a worksheet to protect passwords, what should I do? You just follow these steps, and the Excel worksheet password is instantly broken! 1, open the Excel file that you need to break the password for protection; 2, click the tools on the menu bar -- macro -- record new macros, enter macro names, such as: aa; 3. Stop recording (so get an empty macro); 4, click the tools on the menu bar macro - macro, select AA, point edit button; 5, delete all characters in the window (only a few), replace the following content; Begin copying from below the line ------------------------------------------------------------------------------------------ Option Explicit 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, passwords Const, DBLSPACE, As, String = vbNewLine vbNewLine Const AUTHORS As String = DBLSPACE vbNewLine _ Adapted from Bob McCormick base code by _ Norman, Harker, and, JE, McGimpsey. Const HEADER As String = AllInternalPasswords User Message Cons