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.
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.
