Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
password protecting sheet when workbook opens
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password Protecting a workbook | Excel Discussion (Misc queries) | |||
What if I forgot the password protecting an excel workbook? | Excel Discussion (Misc queries) | |||
Password protecting sheets in a workbook | Excel Worksheet Functions | |||
Sheet Protecting password | Excel Discussion (Misc queries) | |||
Protecting Sheet with Password | Excel Programming |