Thanks for your reply. Say cell C2 contains "Charter (lite)" and I click on N2, the code works and the error message comes up. However, after clicking Ok, the whole sheet (every cell) becomes protected and the sheet needs to be unprotected in the Info menu. Is there a way to stop that from happening?