Excel Workbook Password Lost

[GRKira]

Hi Gurus
Hope you are all keeping safe and well.
One of my spreadsheets has the Workbook structure password protected however the password doesn't work - I have tried various things like Caps Lok on/off first letter caps and rest not and vice versa. Can not figure out how or why. I need to unprotect the workbook. All the worksheets are unprotected as they responded to the password.
Is there any way of unprotecting the workbook without the password please?
Thanks
Pam

[HansV]

Open the workbook.
Press Alt+F11 to activate the Visual Basic Editor.
Press Ctrl+G to activate the Immediate window.
Type or copy/paste the following line

Code: Select all

ActiveWorkbook.Sheets.Copy

Press Enter.
Switch back to Excel.
You now have an unprotected copy of the workbook.
Don't forget to save it.

[GRKira]

Thanks Hans - did that but the Protect Workbook is still highlighted. See attached screen shots - did I do the VB correct?
Thanks
Pam

[HansV]

You have to click inside the line ActiveWorkbook.Sheets.Copy before pressing Enter. Excel should then create a copy of the workbook.

[adeel1]

Hi sir

that the super revealing
just for learning point of view.

i created one dummy WBk its totally blank, i did follow the steps but i have error

Capture.PNG

Adeel

[GRKira]

You are absolutely marvelous Hans - worked that time, thank you so much :)

[HansV]

Hi Adeel, that workbook has been protected for opening.

Pam mentioned a workbook protected for structure. I assumed that she meant that Protect Workbook had been clicked on the Review tab of the ribbon.

S0488.png

Such a workbook can be opened normally, but you cannot insert, delete or move sheets.

[adeel1]

Ahh, thnx for knowledge and still it is good for learn and great idea/technique.

Adeel