Hi, I have formatted the cells in a worksheet so that when i send the file out people can only enter information which is valid.

however i want too lock the worksheet so no one can mess around with the validation of the cells

Whenever i lock it though people cant even input into the cells.

I want them to be able to input into cells, but nothing else

Can someone help please?