simora
01-24-2010, 02:45 AM
I am trying to protect a sheet (!) at startup. I've tried doing so using the Private Sub Workbook_Open() to place the code, and also using Private Sub Workbook_BeforeClose . Either way, I keep getting a
Run-time error '9' Subscript out of range error.
I have a button on sheet (1) which brings up an input box for a password. When I try to use
Worksheets(1).Protect
OR
Worksheets("Home-Page").Cells.Locked = True
after the password is resolved, I still get an error.
How can I resolve this?
Thanks
Run-time error '9' Subscript out of range error.
I have a button on sheet (1) which brings up an input box for a password. When I try to use
Worksheets(1).Protect
OR
Worksheets("Home-Page").Cells.Locked = True
after the password is resolved, I still get an error.
How can I resolve this?
Thanks