I have this simple enough:
' run this when the workbook is opened
Private Sub workbook_open()
ActiveWorkbook.Protect Password:=mypassword, Structure:=True, Windows:=False
End Sub
when I open my workbook, the workbook is protect. I click on unprotectwork book and it doesn't prompt for a password, it just automatically unprotects it.
Anyone know whats wrong?
Thanks
Bookmarks