• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

A present for everybody that can use it

I got so so much help from this forum, here is a little present for the people that forgot there password in excel
Activate the page you want to unlock
It is in Dutch but all code is open
I Hope I can help somebody
Comments welcome
see file
 

Attachments

  • Beveiliging pleite(Dotchie) - Chandoo.XLSM
    32.7 KB · Views: 8
Do you have English version?

Thanks!.

I got so so much help from this forum, here is a little present for the people that forgot there password in excel
Activate the page you want to unlock
It is in Dutch but all code is open
I Hope I can help somebody
Comments welcome
see file
 
I can try , my native language is not English but te code is VBA
But tomorrow I try to send the same file in English, I realy want to do something back for Chandoo forum
 
Here is the English version, I hope it is helpfull
Some extra information.
Make sure the excel file you want to unprotect is closed.
If you want to unprotect a sheet activate that sheet first, save and close.
Please give some reply if it is helpfull
 

Attachments

  • Beveiliging pleite(Dotchie) - Chandoo.XLSM
    40.4 KB · Views: 12
Hey dotchieJack,

Great job done!.

It would be great if you add "notification or to do before using this tool" like youo have mentioned below.

Just an suggestion.


Here is the English version, I hope it is helpfull
Some extra information.
Make sure the excel file you want to unprotect is closed.
If you want to unprotect a sheet activate that sheet first, save and close.
Please give some reply if it is helpfull
 
Thanks for the present dotchiejack
I tested your English version .. but it took too long time and no good point I reached
Just searching and the sheet is still protected ..
Generally thanks for the present and waiting for more :)
 
FWIW, although I admire the desire to give something back, there are better versions of this code already discussed here, and many versions available that will simply work on the active workbook or worksheet, as required.
 
Back
Top