I want a sheet in my workbook to be automatically protected when i
opens. So, I put this into 'ThisWorkbook':
Private Sub Workbook_Open()
Password = "jack"
ThisWorkbook.Sheets("invoice list").Protect Password:=Password
End Sub
Then I closed the workbook, reopened it, and the sheet was protected
However, I am now unable to unprotect it, as I keep getting told tha
I've got the wrong password!
Firstly, does anyone know how I can unprotect this? Secondly, what di
I do wrong? how can I get this to work?
Thanks!
--
mercer7
-----------------------------------------------------------------------
mercer77's Profile:
http://www.excelforum.com/member.php...fo&userid=3148
View this thread:
http://www.excelforum.com/showthread.php?threadid=51164