So I have a document that many people that aren't at all excel savvy will be entering info into. I'd like them to be able to type in text, but not do anything else with the cells. No copy/paste, no deleting cells/rows, and no dragging to copy things. I understand that I can't use the protect worksheet function to accomplish this. I'm using Excel 2007. The cells that need protecting are B3:F1000 (column C has a drop-down data validation menu they need to be able to use if that makes a difference). Any ideas?


Also - is there a way to have a message pop up if they enter something in column F but not in column B? Like "please enter a date"