Password Protected Worksheet without Password

[wmunsey81]

I just put in VBA for 'ThisWorkbook:

Private Sub Workbook_Open()
OpenWHSE.Show
Sheet2.Protect Password:=True, UserinterfaceOnly:=False
End Sub

After running it, it protected the stuff I want. I want to do some more editing and go to unprotect, and says I didn't put in the correct password... I never put in a password in the first place. Is there a default? Help! I don't have a previous version of this and I think I locked myself out of my own excel.

 

[Fluff]

This section is setting the password

Password:=True

so you have given it a password of TRUE (all caps)

 

[wmunsey81]

This section is setting the password

Password:=True

so you have given it a password of TRUE (all caps)

Still not letting me in. Going to Unprotect Sheet and says incorrect password

[COLOR=#000000][FONT=verdana]Private Sub Workbook_Open()[/FONT][/COLOR]
[COLOR=#000000][FONT=verdana]Sheet1.Protect Password:=True, UserinterfaceOnly:=True, AllowFiltering:=True[/FONT][/COLOR]
[COLOR=#000000][FONT=verdana]Sheet3.Protect Password:=True, UserinterfaceOnly:=True, AllowFiltering:=True[/FONT][/COLOR]
[COLOR=#000000][FONT=verdana]Sheet4.Protect Password:=True, UserinterfaceOnly:=True, AllowFiltering:=True[/FONT][/COLOR]
[COLOR=#000000][FONT=verdana]Sheet5.Protect Password:=True, UserinterfaceOnly:=True, AllowFiltering:=True[/FONT][/COLOR]


[COLOR=#000000][FONT=verdana]End Sub[/FONT][/COLOR]

Saw this in a post and did it... biggest mistake ever.

 

[wmunsey81]

Gives "Run-time error '1004': if done in VBA and same message if going into Review... Running 2016 Excel.

 

[wmunsey81]

SOLVED: Tried "FALSE" and it worked... Thank you for the hints.

 

[Fluff]

Just seen post#5

Glad it's sorted & thanks for the feedback