locking and unlocking a row of data based on whats entered in a cell
I would like to have a protected workbook where the data
is protected.
I would like to have a column for each row where you could
put an x or any other character in to mark that changes
were done to that row. I would like this character to
unlock that row to allow data to be changed.
So basically they have this huge list of data and they
need to make a change to data in one row for one product.
They would put an x in column a to unlock that row and
then be able to change data in any other column for that
product which was previously locked down.
Any ideas on best way to do tho?
|