Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

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!

This post first appeared on HeaT SeekeR, please read the originial post: here

Share the post

Remove excel password without the password


Subscribe to Heat Seeker

Get updates delivered right to your inbox!

Thank you for your subscription