Good day Excel wizards! Im look for some help preventing an issue from happening (cause it already happend)
I have a workbook full of test certification forms where users enter test results, sign off, and send off to be reviewed (buddy check system)
The problem:
After the form has been completed, signed, and reviewed. A unknown user accidentally changed the results of a test sample.
The solution:
I want to make it so once the form has been reviewed ALL unprotected cells are password protected automatically.
For example: I have attached a sample form to this thread. All cells in yellow or red are required to be filled out with the exception of 1-2 cells which can be modified if needed. All other cells are locked.
What I am looking for is IF cells C39 & G39 are NOT blank THEN the entire sheet becomes password protected. This should prevent any accidental changes to the data, only select personnel will have the password to unlock and edit. I lack the VBA knowledge to even know where to start, hopefully someone can help!
Thank you in advanced.
Bookmarks