UnLock Microsoft Excel Password locked Excel Worksheet

Unlock password Protected worksheet in Excel

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

screenshot1

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

screenshot2a

Please use the above to unlock your own worksheets.

Disclaimer:
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