Capture Copy via Click and Drop (no cutcopymode)

[tmktech]

Happy Holidays, everyone!

I could sure use some help on this. I've got an EXCEL VBA app which captures copy events in order to retain / restore cell formats from a hidden sheet "template".

I use the cutcopymode and it works great EXCEPT when one grabs (the bottom right corner) and drags to copy cells. Is there any state or otherwise that I can check whitin the Worksheet_change event to know if cells have been updated via this method of copying?

Thanks in advance!

TMKTECH

 

[Loomah]

Hi
I don't know about capturing the event but how about preventing it from happening

Application.CellDragAndDrop = False

Set to false in the workbook open & activate events and set to true in the workbook close and deactivate events so that other workbooks aren't affected.

Just a thought!
;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244

 

[xlbo]

Concur with Loomah. To the best of my knowledge, there is no way to trap this action

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[TonyJollans]

Hi tmktech,

Within the WorkSheet Change Event you are given the address of the (target) range of cells which is being changed, regardless of the source of the data (which could be from outside Excel anyway). I presume you are using CutCopyMode to determine if a change has been made to the Source cell(s) (i.e. a Cut) but I'm not sure how you know what the source cells are. There is no question of that with a Fill, so if CutCopyMode = False then do you not have all the information you need? Or have I missed something obvious?

Enjoy,
Tony