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. |
How do I prevent certain Paste options
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. |
All times are GMT +1. The time now is 03:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com