The following .xls file can be used to remove internal protections in excel (i.e. workbook & worksheet).
Instructions after downloading the file from the given link:
1. Load the file: "allinternalpasswords.xls" in excel
2. If asked, Enable Macros
3. Go to: File > Open...
4. Select and open the excel file you want to remove the protection from
5. Go to: Add-Ins > Remove Passwords or if older version execute/run macro with name "allinternalpasswords.xls!AllInternalPasswords"
6. After macro finishes task (it takes some seconds depending also on PC speed), save the unprotected workbook with a new name.
7. Your coffee is getting cold, have a sip now.
Direct Link:
allinternalpasswords.xls (Size: 28.5 KB / Downloads: 464)
WARNING: SOME EXCEL WORKBOOK AUTHORS INCLUDE ALGORITHMS THAT CHECK IF THE WORKBOOK HAS BEEN ALTERED OR UNPROTECTED. IN SOME CASES THE UNPROTECTED WORKBOOKS CAN GIVE FALSE RESULTS AND/OR LOSE FUNCTIONALITY. ALWAYS DOUBLE CHECK!!!
Also, if you modify an excel workbook by unprotecting it and you post it here, also post the original one and make a note about this in your post. Engineering is an exact science; mistakes can cost lives, money ans careers so we should be careful when modifying original code.
Instructions after downloading the file from the given link:
1. Load the file: "allinternalpasswords.xls" in excel
2. If asked, Enable Macros
3. Go to: File > Open...
4. Select and open the excel file you want to remove the protection from
5. Go to: Add-Ins > Remove Passwords or if older version execute/run macro with name "allinternalpasswords.xls!AllInternalPasswords"
6. After macro finishes task (it takes some seconds depending also on PC speed), save the unprotected workbook with a new name.
7. Your coffee is getting cold, have a sip now.
Code:
***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:
http://forum.civilea.com/thread-27464.html
***************************************
Direct Link:
allinternalpasswords.xls (Size: 28.5 KB / Downloads: 464)
WARNING: SOME EXCEL WORKBOOK AUTHORS INCLUDE ALGORITHMS THAT CHECK IF THE WORKBOOK HAS BEEN ALTERED OR UNPROTECTED. IN SOME CASES THE UNPROTECTED WORKBOOKS CAN GIVE FALSE RESULTS AND/OR LOSE FUNCTIONALITY. ALWAYS DOUBLE CHECK!!!
Also, if you modify an excel workbook by unprotecting it and you post it here, also post the original one and make a note about this in your post. Engineering is an exact science; mistakes can cost lives, money ans careers so we should be careful when modifying original code.