| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set Save Options? | Excel Discussion (Misc queries) | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
| I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
| Paste Special Question | Excel Discussion (Misc queries) | |||
Linear Mode
