I have a workbook from which I need to copy & paste multiple rows into a non-Excel program. If I Ctrl+Click the rows I want and then copy them, it copies everything between the first and last row, not just the highlighted row. Is there any way to disable this "feature"?

I wrote a macro that will copy only the highlighted rows to the clipboard and set Ctrl-C as the shortcut key for it. The problem is that some people prefer to right click and select copy (or click the copy icon from the ribbon) rather than pressing Ctrl-C. Is there any way to trigger the macro any time a copy takes place, regardless of how it is triggered?

Also, for the benefit of anyone who stumbles across this thread looking for a way to copy only the highlighted lines, I'll include the macro I'm using. There's probably a more elegant way to accomplish it, but this works:

Please Login or Register  to view this content.
(Looking at it now, I realize I could have have cut out several lines by wrapping the repeated S= in another For loop. I'm sure there are other improvements that could be made as well, but it's a moot point if it can't be triggered via RightClick-Copy and the Copy icon.)