Hello All,
Looking for some help on how I can easily Lock/Protect table information. What we have is 2 QC people that enter information into a table and one of them has to sign it off. Once it is signed off we need to lock it so nothing can be changed. Is there a way this can be done with a button but only lock the rows that have information in them and also have a final approve note that comes up to double check the information is correct? Currently we highlight format lock and use the protect sheet and enter a password every time. Looking to make this easier. Up for any help or advice.
Looking for some help on how I can easily Lock/Protect table information. What we have is 2 QC people that enter information into a table and one of them has to sign it off. Once it is signed off we need to lock it so nothing can be changed. Is there a way this can be done with a button but only lock the rows that have information in them and also have a final approve note that comes up to double check the information is correct? Currently we highlight format lock and use the protect sheet and enter a password every time. Looking to make this easier. Up for any help or advice.