I have a worksheet for data entry. I found a Visual Basic code that allows me to have a manager be able to unlock the cells they need to enter data on, and will also unlock previously entered information, so if staff make a mistake, supervisors can fix it. It works perfectly on one sheet. After some discussion, the managers would like several tabs of data. That way staff don't have to look in three to four different documents to enter data. I keep getting a run time error when I try to add another cell range to the code. And then i can't get the check box to ask for a password, etc. I also have a "button" created so that they can just click that to autofill the dates for them. The managers are not at all Excel savvy so I'm trying to make it as painless as possible. I have conditional formatting on, so they know if data has not been entered easily. I have data validation working well. I just can't get the code(s) to work across several worksheets because I do not not Visual Basic well.
These templates will be used for about 180 different individuals, with about 18 managers with their own "templates" for their individuals. They all have different information that is needed on a monthly basis.
I've uploaded the file in case you want to see what I have done. Passwords are: for manager password, sheets admin.