Mereset Password Proteksi Sheet dan Workbook pada File Excel

Berikut ini copy-paste dari situs ini mengenai cara mereset (bukan mengetahui atau menampilkan) password proteksi sheet dan workbook file Excel jika anda lupa password milik anda (bukan milik orang lain ya).

Untuk mereset password pada file excel, menggunakan file add-in (.xla) yang disediakan oleh si pembuat (bisa di donlod pada situsnya, dalam dikemas dalam file .zip) atau kalau males, donload di sini saja.

Disclaimer :  penulis tidak bertanggung jawab atas segala kerusakan atau kerugian yang disebabkan oleh pemakaian atau penyalahgunaan cara mereset password yang diposting ini.

Instructions for pre 2007 versions of Excel

Loading this add-in in Excel gives you two extra menu-items on the bottom of the "Tools"-menu (or equivalent in non-English versions of Excel). These are:

1. Unprotect workbook
2. Unprotect sheet

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_2007_2010.xlam to the trusted locations.
Under "Excel options"-"Trust center"-"Trust center settings..."-"Trusted Locations"-"Add new location", add the path to where password_2007_2010.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_2007_2010.xlam
The new menus are:
1) Unprotect sheet
2) Unprotect workbook
3) Unprotect all (PRO version only)
The first two removes protection from active sheet/workbook, and 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. 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.
The image below shows the new menu items: