August 7, 2014

Remove excel password without the password

Sometime we protect our Excel spreadsheet to make it easier for sharing and of course, to prevent us and anyone to make a silly mistake and delete all the formula in a cell.
There will be time when we need to update some formula or the format of our spreadsheet. Since this will most likely happen once in a blue moon, often, we already forgot the password to unprotect the document.

In case this happen to you, here is some code for you to remove that password without any special software. To make this work, Open your protected document, then press ALT+F11, to bring the Visual Basic Application Console. On the menu above, go to Insert > Module.

Copy and paste the following code to your Module


Then press F5 to run the application.
Voilla! You just remove your password!

1 comment:

  1. Fine information, many thanks to the author. It is puzzling to me now, but in general, the usefulness and importance is overwhelming. Very much thanks again and best of luck!

    ReplyDelete

Whats your thought on this post?