paste special
 

I have a spreadsheet where sometimes people copy information over from a
previous worksheet. Problem is it sometimes stops the formulas working
because it gives a bad reference. Is there any way of programming so that
when the spreadsheet is open and the user goes to copy and paste that when
they paste it does a paste special and only paste the values without them
haveing to go into paste special?