Thanks in advance for any help given!!

I have a template spreadsheet that is formatted (ie. colors, number format, borders, etc). I want to be able to protect the format while allowing the user to copy data into the cell....basically only allowing "paste values".

I am pretty sure I need to use an "event change" macro, but I am not sure how exactly to say "if someone pastes something into my spreadsheet accept only the value (or restore all original formatting)".

any suggestions?