Ads (728x90)

Cara membuka Protect Sheet (Unprotect Sheet) di Excel, dengan menggunakan fasilitas Add-In.
Langkah-langkah melakukan Unprotect Sheet di Excel, adalah sebagai berikut :

1. Buka File Excel yang akan di Unptotect;
2. Download file unprotect_excel_03.lxa atau unprotect_excel_07_10.lxam, lalu jalankan (double-click) unprotect_excel_03.lxa (untuk file excel MSO-2003) atau unprotect_excel_07_10.lxam (untuk file excel MSO-2007 / MSO-2010) Add-In;
3. Jika muncul tampilan seperti di bawah ini, maka pilih Enable Macros;

4. Jika muncul tampilan Excel Password remover now loaded, pilih Ok;

5. Lalu pilih menu Tools, Unprotect Sheet, atau pilih tab "Straxx" pada MS-Excel 2007/2010;

6. Kemudian pilih Unprotect yang anda perlukan, dan tunggu beberapa saat hingga muncul seperti di bawah ini, lalu Ok;

7. Selesai. File anda sudah tidak ter-protect lagi.

DOWNLOAD FILE (Untuk File Excel MSO 2003)
DOWNLOAD FILE (Untuk File Excel MSO 2007 / 2010)

Catatan :
Cara di atas tidak diijinkan digunakan untuk merugikan atau mencurangi orang lain (tidak boleh dipergunakan untuk hal-hal yang negatif), jika anda menggunakan untuk keperluan lain, itu diluar tanggung jawab pembuatnya apalagi saya.

Selamat mencoba.
-----

Unprotect Password di Excel 2003

1. File [password.zip/downoad di http://www.straxx.com/excel/password.html] di extract dulu (terserah extract di mana), untuk lebih mudahnya, extract saja pada folder tempat anda men-download.
2. Buka File Excel --> cari Tools --> Add-ins [klik]
3. Setelah jendela Add-ins terbuka klik Browse
4. Setelah itu cari file [password.xla] yang telah anda extract tadi.
5. Cari file dengan nama password.xla, lalu klik OK
6. Akan [ada Add-ins tambahan] dengan nama password remover [centang] klik OK
7. Pilih Tools (lagi), cari Unprotect Sheet.
8. Maka file anda telah ter-unprotect.
=====
Source
Have you ever forgotten your Excel workbook or sheet password?
Here you can download a FREE Excel add-in that removes/cracks sheet and workbook password protection in Excel®.
NB! This program can't remove file protection, i.e. if you are unable to open the file, this program won't help you. You could try Excel Key to remove file protection. If you need to crack the VBA-password try this one.
This Excel add-in (password.xla) works fine in Excel 5.0 and above (including Excel 2000, XP, 2003, 2007 and 2010).
This program will remove passwords of any length, also passwords containing special characters.
Download here:
Excel 2007/2010 version: password_2007_2010.xlam  (zipped: password_2007_2010.zip)
Previous Excel versions: password.xla  (zipped: password.zip)

Poskan Komentar

Blogger
  1. makasi om, sangat bermanfaat nih addins nya

    BalasHapus
  2. Mantapppp
    Ijin download Gan
    Tenkyu

    BalasHapus
  3. tolong gan maksud dari rumus berikut artinya apa yah?

    =imran!$AG$15&"-"&imran!$AG$16&"-"&imran!$AG$17&"-"&imran!$AG$18

    sama ini gan

    =imran!AG9&"-"&imran!AG10&"-"&imran!AG11&"-"&imran!AG12

    mohon pencerahanya gan? thx

    BalasHapus
    Balasan
    1. imran! adalah nama sheet yang dipanggil
      $AG$15 (dan sejenisnya adalah cell yg dikunci, jadi saat di copy ke bawah atau ke samping, hasilnya akan tetap sama)
      tanda (dan) & adalah penghubung
      sedangkan tanda petik dua diantara "-" adalah fungsi untuk mengisikan string/karakter huruf atau angka
      AG9 (dan sejenisnya adalah cell yg bisa berubah ketika di copy sesuai arah copy-paste nya)
      bisa dipahami? :)

      Hapus
  4. GK BS OM.. BGMN CARANYA,,,

    BalasHapus
  5. terima kasih om...luar biasa bermafaat infonya, semoga sukses sll.

    BalasHapus
  6. ass dulu saya coba berjalan dengan lancar tapi sekarang sudah tidak jalan tolong suludinya dan semoga bermanfaat dalam kebaikan

    BalasHapus
  7. saat kita buka file yg mw di unprotect, kan muncul tuh popup password, nah,, pas kita buka file unprotect_excel_07_10.xlam, gk kebuka gan, gk ada menu Straxx... yg aktif cuma file yg mw di unprotect aja.

    BalasHapus
  8. Gan, muncul : this version of " Excel Passsword Remover 2012" has expired.
    ijin sedot file uptodatenya gan.
    thanks

    BalasHapus
  9. mantap gan..walau dah expaired tapi masih bisa dipake gan...tested banget...makasih bro

    BalasHapus
  10. Excellent web site you have got here.. It’s hard
    to find excellent writing like yours nowadays. I really
    appreciate people like you! Take care!!

    Also visit my web page ... 3d sex games

    BalasHapus
  11. I really like your writing style, excellent info, thank you for posting :
    D. "I will show you fear in a handful of dust." by T. S. Eliot.


    Also visit my blog psn code generator

    BalasHapus
  12. You are my inspiration, I possess few blogs and occasionally run out from post :
    ). "He who controls the past commands the future. He who commands the future conquers the past." by George Orwell.



    Also visit my blog; aimbot mw3

    BalasHapus
  13. Great post.

    my homepage: miscrits cheat

    BalasHapus
  14. Excellent goods from you, man. I have understand your stuff previous to and you're just extremely magnificent. I actually like what you have acquired here, really like what you're saying and the way in which you say it.
    You make it entertaining and you still care for
    to keep it sensible. I cant wait to read much more from you.
    This is actually a wonderful website.

    Also visit my page - money making

    BalasHapus
  15. Hi there everyone, it's my first pay a visit at this web page, and post is genuinely fruitful in favor of me, keep up posting these articles or reviews.

    Also visit my web-site youtube auto

    BalasHapus
  16. I get pleasure from, lead to I found exactly what I used to be looking for.
    You have ended my four day lengthy hunt!
    God Bless you man. Have a great day. Bye

    Feel free to visit my weblog; Primitive and easy to crack passwords common in the UAE

    BalasHapus
  17. Hola! I've been reading your web site for a long time now and finally got the bravery to go ahead and give you a shout out from Lubbock Tx! Just wanted to tell you keep up the excellent job!

    my web blog - Cheats FüR Castleville

    BalasHapus
  18. You really make it seem so easy with your presentation but
    I find this matter to be really something which I think I would never understand.
    It seems too complex and extremely broad for me.
    I am looking forward for your next post, I'll try to get the hang of it!

    Also visit my homepage ... Virtuel Currency

    BalasHapus
  19. Awesome post.

    Feel free to surf to my weblog ... cheat for castleville

    BalasHapus
  20. It is in reality a great and helpful piece of info.
    I'm happy that you shared this useful info with us. Please keep us informed like this. Thanks for sharing.

    my homepage: clicksia

    BalasHapus
  21. Unquestionably believe that which you stated.
    Your favorite reason appeared to be on the web the easiest thing to be
    aware of. I say to you, I definitely get irked while people consider worries that they just don't know about. You managed to hit the nail upon the top and defined out the whole thing without having side-effects , people can take a signal. Will likely be back to get more. Thanks

    Feel free to visit my web blog best cheats for miscrits game

    BalasHapus
  22. Hello, yeah this piece of writing is in fact nice and I have learned lot
    of things from it regarding blogging. thanks.

    My weblog :: adult sex games

    BalasHapus
  23. No matter if some one searches for his vital thing, therefore he/she
    needs to be available that in detail, so that
    thing is maintained over here.

    Have a look at my web-site: great Gpt site

    BalasHapus
  24. Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your
    point. You definitely know what youre talking about, why throw away your intelligence on
    just posting videos to your site when you could be giving us
    something enlightening to read?

    Here is my web-site ... cheat in castle ville **

    BalasHapus
  25. This paragraph is truly a pleasant one it assists new net visitors, who are wishing
    for blogging.

    Also visit my weblog :: lost password

    BalasHapus