View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marie J-son[_5_] Marie J-son[_5_] is offline
external usenet poster
 
Posts: 22
Default "Remember" second last clipboard?

Hi,

I got code doing copy & paste running - it has to be copy paste because I
use it to restore links if someone make drag & drop with the refrenece cell.
To overcome this, I use cells with "relative liks" to paste back into the
reference cell that was broken.

however, as trigger I has a worksheet_event and this means that if I a user
try to do a copy paste, their clipboard get overwritten by my code.

Can anybody find a solution to "remember" the clipboard for the user before
I ran the code? A solution could else maybe be to restore the links by
cells.formula ="=...' cod of some kind. Any code snippets of that, by the
way?

/Regards