Looking for help with protecting cells

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"

To answer your first question, it really depends on the layout of your sheet and how many cells you need them to fill in. If it's not too many I would just create a userform for them to fill out then popluate the required cells.

As to your second question, here is a solution:

Please Login or Register  to view this content.

Thank you, I believe that a userform is probably the best solution. I will try out that code though, could be useful for a few other things I have.