Facts:
We have a protected worksheet wherein all rows represent data pertaining to one client invoice
e.g. Row 3 have data pertaining to Invoice No. 1 from column A to X
wherein data can only be selected from drop down lists in column A to J (unprotected cells)
Column K to X are protected cells which calculate or pick the data from other sheets based on drop down selected in column A to J
(similarly row 4,5,6,.... have data pertaining to invoice no. 2,3,4,......)
In column Y we have header as "Printed" and data can be selected from drop down as either "Yes" or "No" or can be blank ""
Query: How to lock the complete row (only 1 selected row) when the value column is selected as "Yes"
(For any error caused by user, only admin has the sheet password to unlock and rectify the error).
PS: I have tried taking the cue from earlier post but couldn't find the solution. Apologies in case solution is already given by learned members in the forum.
We have a protected worksheet wherein all rows represent data pertaining to one client invoice
e.g. Row 3 have data pertaining to Invoice No. 1 from column A to X
wherein data can only be selected from drop down lists in column A to J (unprotected cells)
Column K to X are protected cells which calculate or pick the data from other sheets based on drop down selected in column A to J
(similarly row 4,5,6,.... have data pertaining to invoice no. 2,3,4,......)
In column Y we have header as "Printed" and data can be selected from drop down as either "Yes" or "No" or can be blank ""
Query: How to lock the complete row (only 1 selected row) when the value column is selected as "Yes"
(For any error caused by user, only admin has the sheet password to unlock and rectify the error).
PS: I have tried taking the cue from earlier post but couldn't find the solution. Apologies in case solution is already given by learned members in the forum.