Menu

Detect copy and paste action

Search this Thread

Prev

Previous Post

Next Post

Next

#3

Report Post

Posted to microsoft.public.excel.programming

Bret Bernever Bret Bernever is offline

Bret Bernever is offline

external usenet poster

Posts: 27

Default

Detect copy and paste action

In article ,
says...

You cannot tell within Worksheet_Change whether the user pasted an entry in
versus typing it in, as far as I know. You're concerned about your formats
getting blown away?

Well, something like that!

If a user enter some data in a certain range, the worksheet_change event
catches that and triggers a userform (where some additional data can be
entered).
But that isn't necessary (presenting the userform) in case the user does
a copy and paste.

I will look for another approach to tackle this.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excell copy action pauses for 15 second for the smallest action	Meekal	Excel Discussion (Misc queries)	1	January 28th 10 04:30 PM
protecting ceels to copy -paste action	grigoras victor	Excel Worksheet Functions	1	June 19th 06 12:36 PM
protecting ceels to copy -paste action	grigoras victor	New Users to Excel	0	June 19th 06 07:15 AM
protecting ceels to copy -paste action	grigoras victor	Excel Discussion (Misc queries)	0	June 19th 06 07:14 AM
How do I capture user paste action and convert to Paste Special	DonC	Excel Programming	0	November 19th 04 01:43 PM

All times are GMT +1. The time now is 01:10 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement