Capture paste from Office Clipboard

's Computer Specifications

Hi,

A bit of background first

I have an event macro which I want to prevent from running if the user
paste some info from the office clipboard into a cell as it triggers
my events.

The below code works if the data is copied from one section of the
spreadsheet to another. Is there anyway to capture Ctrl + V using
select case?.

Select Case Application.CutCopyMode
Case Is = False
MsgBox "Not in Cut or Copy mode"
Case Is = xlCopy
MsgBox "In Copy mode"
Case Is = xlCut
MsgBox "In Cut mode"
End Select

FYI
I also looked at the on key event but didn't want to add a new module
to the workbook if I can avoid it
Application.OnKey "^v", "Macro1"

If I had to add a module I guess Chip site would be the best start??
http://www.cpearson.com/excel/vbe.aspx

Any suggestions of tips would be appreciated

Regards

VBA Noob

's Computer Specifications

Anyone got any suggestions ??

Danny

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I can't paste from the office clipboard	=?Utf-8?B?bm9vZnNxdWlkaXM4?=	Microsoft Excel Misc	7	25th Jun 2008 07:28 PM
Clipboard gets empty by itself, cleared clipboard, copy paste doesn't work, outlook clears clipboard, problems with clipboard - possible solution	Jens Hoerburger	Microsoft Outlook	0	24th Aug 2006 02:44 PM
Why can't I paste fron Office Clipboard?	=?Utf-8?B?VG9tIE0=?=	Microsoft Word Document Management	1	2nd Dec 2005 07:28 PM
How do I disable Office Clipboard so Copy Paste uses traditional Windows Clipboard	dwilliamson@ivsi.com	Microsoft Excel Discussion	10	24th Feb 2005 02:36 PM
Copy / Paste Function & the Office Clipboard	=?Utf-8?B?S2FyZW4=?=	Microsoft Excel Misc	2	17th Feb 2005 02:41 AM