dsheard2015
Board Regular
- Joined
- May 10, 2016
- Messages
- 134
Hello again!
I have a protected sheet, "Form 34-4 (1)", with all data entry cells unlocked, cells A12:U31. When a student logs in to the workbook a "1" is placed in cell Z1. What I need to happen is when cell Z12="1" then cells A12:S31 and U12:U31 will become locked, giving the student access only to cells T12:T31 where they can enter their initials. Also, just the opposite, when cell Z12="" then cells A12:S31 and U12:U31 will become unlocked giving full access to the instructor for data entry but locking cells T12:T31.
The sheet is password protected. The password is "22068"
I have found numerous ways on the forum to do something similar to what I need however, I haven't found a solution to work exactly how I need it to.
Thanks again for the help, you guys are great!
dave
I have a protected sheet, "Form 34-4 (1)", with all data entry cells unlocked, cells A12:U31. When a student logs in to the workbook a "1" is placed in cell Z1. What I need to happen is when cell Z12="1" then cells A12:S31 and U12:U31 will become locked, giving the student access only to cells T12:T31 where they can enter their initials. Also, just the opposite, when cell Z12="" then cells A12:S31 and U12:U31 will become unlocked giving full access to the instructor for data entry but locking cells T12:T31.
The sheet is password protected. The password is "22068"
I have found numerous ways on the forum to do something similar to what I need however, I haven't found a solution to work exactly how I need it to.
Thanks again for the help, you guys are great!
dave
Last edited: