I have a spreadsheet that has a range A5:H30 being used as a list of product
numbers entered in Column A (A5:A30) and a vlookup in the remainder range
b5:h30 (locked cells) to fill in the remaining order information. Range
G5:G30 (locked) is the Rate. I protect the sheet to allow only unlocked
cells to be selected to ensure data integrity. My issue is that now I have
certain product numbers that have a variable Rate that needs to be entered
at the time the order is being entered. Is there a way to unprotect the
sheet, unlock Range G(whatever row contains the variable product number) so
that the variable rate can be entered, and then once entered, set the order
form back to the protected state. I can probably work the code but just
don't know the property to change the cell protection option. I thank you
in advance!

Amb