I've done this by customizing the ribbon to remove that functionality
http://www.rondebruin.nl/ribbon.htm
I also added some code to catch the keyboard commands and have them do
something different
http://www.jkp-ads.com/Articles/CatchPaste.asp
It was kind of complicated to do it, but given some constraints I had, it
was what needed to be done.
--
HTH,
Barb Reinhardt
"Aman" wrote:
Can you help me with VBA code? because i want t keep the formatting and
condition on cells as i did and disable the user to use copy and past from
another unformatted cell