Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Within this Discussion Group, I have searched for "restrict pasting" and
"prevent pasting", but I have been unable to find a thread that solves my problem. I want to prevent users from pasting anything in a cell except for values. So when a user copies some data and attempts to paste it in a cell using Edit | Paste, Ctrl-v, the Paste button, or the right-click menu and selecting Paste, I want the paste operation to behave as if the user had selected Paste Special | Values. Can this be done programmatically? If so, and being a novice to VBA, I would be grateful for any assistance. Thanks, Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Preventing copy/paste on validated cells | Excel Discussion (Misc queries) | |||
Copy Paste Macro not Pasting Values when Blank | Excel Programming | |||
Paste Values not pasting numbers | Excel Discussion (Misc queries) | |||
Preventing cutting/pasting | Excel Programming | |||
Preventing user entering duplicate values in a cell range | Excel Worksheet Functions |