Set up a macro for past special (you can use record macro) assign it to
ctrl-v and that will execute paste special instead of paste -- they would
still be able to use Paste off the menu though....

wAyne_

"soldier33w" wrote:

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.