This program works on the active workbook in Excel.
This program gives you 2 or 3 new menu items in Excel:
1) Unprotect sheet
2) Unprotect workbook
3) Unprotect all (PRO version only)
The first two removes protection from active sheet/workbook, and the PRO version displays a password that works (most probably not the same as the original).
“Unprotect all” removes workbook protection (applied with “Tools”-”Protection”-”Protect workbook”) and all worksheet passwords in the active workbook. It displays no message at the end, it just stops running.
When the program is running, look to the Excel status bar (on the lower left) which will display the running time.
If Excel appears to freeze, just let the macro do its work. It may take up to a few minutes in Excel 2007, in Excel 2010 it is very fast (usually within a second).
Instructions for pre 2007 versions of Excel
Loading this add-in in Excel gives you the extra menu-items on the bottom of the “Tools”-menu (or equivalent in non-English versions of Excel).
To load this add-in in Excel: Open it the same way you do with Excel workbooks. Installing the add-in does not work for all users.
Instructions for 2007 and 2010 versions of Excel
You must enable macros when you open the workbook if asked.
If your settings allows macros to run you will find the new menus under “Straxx” (to the right on the menu bar), and you are ready to go.
If not there are two alternatives:
1. Add the location of password*.xlam to the trusted locations.
Under “Excel options”-”Trust center”-”Trust center settings…”-”Trusted Locations”-”Add new location”, add the path to where password*.xlam is stored
2. Set your macro security level one step down.
Under “Excel options”-”Trust center”-”Trust center settings…”-”Macro settings”, set the level down to “Disable all macros with notification”
Close Excel, start Excel and open password*.xlam
The image below shows the new menu items:
Instructions for Excel 2011
Loading this add-in (and accepting macros to run) in Excel gives you the new menu items on the new “Straxx”-menu (just left of the Help-menu).
To load this add-in in Excel: Open it the same way you do with Excel workbooks. Allow macros to run.