View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JBeaucaire[_85_] JBeaucaire[_85_] is offline
external usenet poster
 
Location: Bakersfield, CA
Posts: 45
Send a message via Skype™ to JBeaucaire[_85_]
Default Prevent paste from re-formatting cell

If it's that critical, then diable cut/copy/paste completely in this
workbook. This website gives you code and instructions on where to put it.
Once installed, no one will be able to do that, and will receive a message
onscreen if they try.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=373
--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"BMac" wrote:
Can I prevent someone from accidently pasting info into one
of these cells. If not, how do I get the cell to keep original formatting ,
even if the pasted format is different. Thanks for you help.