I was taught a neat technique whereby, by using Data Validation, I can prevent any data entry in selected cells, without the use of sheet protection.
Out of curiosity, is there a way to accomplish the same thing with VBA so that data entry would be prohibited in specified cells and a customized message would appear if the user attempted to make data entries; something like "data inputs must be made in Worksheet XYZ"