I have created a spreadsheet to be used by my staff for inputing data. Many
of the cells have formulas in them that are protected. However, occasionally
my staff will cut and paste or copy and paste cells from one row or colum to
another, creating errors in the spreadsheet becuase the formula follows. Is
there a way to automatically have the sheet use Paste=Special when the
copy=paste function is used?

Thanks in advance to anyone who may have some input on this...