PDA

View Full Version : Solved: Don't allow user to delete formula in Validation



Djblois
08-29-2008, 09:06 AM
I have set it up so a user selects a cutomer number and then it automatically adds the customer name in the next column using a vlookup formula. and then I set up a data validation rule so that the cells would not accept anything but that formula in the cell. Well I can not figure out one thing, I need to change it so the user cannot delete the formula. How can I do this?

Bob Phillips
08-29-2008, 09:23 AM
Lock that cell and protect the worksheet.

Djblois
09-03-2008, 07:21 AM
Thank you,

I didn't fully understand lock cells. At first it was locking more than I wanted it too but now it works perfectly!!!