How to recover lost worksheet protection password in Excel with VBA code

I download excel template from internet. I noticed that excel sheet is password protected and i unable to do any modification. When i try google it, i found one very useful VBA code which will help to cancel or break the lost worksheet protection password.

1. Open your worksheet which has been protected before.

2. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.

3. Click Insert > Module

4. Paste the following code in the Module Window.

Continue reading