Hi
AFAIK not possible. But you could record a macro while using paste special
and assign a shortcut for this macro

--
Regards
Frank Kabel
Frankfurt, Germany
"Flop" schrieb im Newsbeitrag
...
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...