I'm completely new to this and I really need some assistance. I have a workbook with multiple worksheets that are used to track production for my employees. Each worksheet will need to be protected after they are completed by the employeess so that changes can not be made after the fact. I would like to make the sheets "completed" ian locked out after a dated entry is entered in cell P90. All of the data associated with my entries range from A1-AH388. I would like to use this cell to lock the sheet or range out completely, but have the avalibality as a administrator to go in an make changes with a the password "chm". Any help would be greatly appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Protecting a Worksheet With a Macro After Entering a completion date
- Thread starter ppb4au
- Start date
-
- Tags
- date lock cells password
Similar threads
- Question
