This program works on the active workbook in Excel.
This program gives you 2 or 3 new menu items in Excel (versions up to Excel 2010/2011, for 2013/2016 version see instructions at the bottom of this page):
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).
Only the 2013/2016 version works on files with protection added in Excel 2013/2016 due to stronger encryption algorithm. Previous versions will appear to freeze if used on these files (press ESC several times to abort program).
If nothing happens when you try to open the add-in in Excel:
It is something new with downloaded files, Excel does not open it and reports nothing. If you right click on the file, and choose “Properties”, you see this:
Hook “Unblock” on the Security part at the bottom, and confirm if necessary.
After that you will get the Straxx tab when opening it in Excel.
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.
Instructions for Excel 2013/2016 version
Loading this add-in (and accepting macros to run) in Excel gives you the new menu items on the new “Straxx”-menu as shown in the picture below:
You can either remove protection from a file on your computer (or in the cloud) or from the active workbook. The original workbook is unchanged, but a new workbook with the same name just extended with “_unprotected” is saved (in the same folder as the original), and opened when the program finishes. If used on a file called “Test.xlsx”, the new file will be called “Test_unprotected.xlsx”. All sheet and workbook structure protection will be removed (passwords applied with “Review”-“Protect sheet”/”Protect workbook”).