View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
soldier33w
 
Posts: n/a
Default How do I prevent certain Paste options

I want to limit users ability to Paste anything but Values in my workbooks.
If they just Paste (CTRL-V) then they throw off my formatting and more
importantly, my conditional formatting to alert them of conflicts. How can I
allow users to Paste Special - Values and not Edit - Paste.