UnLock Microsoft Excel Password locked Excel Worksheet

Unlock password Protected worksheet in Excel

Open the workbook, Use Alt+F11 to enter the macro editor.


Once in VBA double click the sheet you need to unlock from the menu listing on the left. Copy and Paste the following code

Run the Macro by selecting Run from the menu bar at the top of the VBA editor screen or simply press F5

Use the code displayed to open the locked WorkSheets


Please use the above to unlock your own worksheets.

The above code was found on Internet, the original website is not found, used the google cache and provided code herewith.
Posted in Automation and tagged , , , , , .

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.