Hi,

A bit too complicated to explain here so if you follow the link below you
can download a workbook of examples.

http://www.savefile.com/files/571204

Mike


"trainerab" wrote:

I need to stop users from being able to copy and paste data into a range of
cells - I need them to type new data into the cells instead

Using Excel XP and 2003