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?
Bookmarks