View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Worksheet_Activate event clears clipboard?

You will have to test it if you want the authoritative answer for your
situation.

--
Regards,
Tom Ogilvy


"Damien McBain" wrote in message
...
So you could still paste into excel but use PasteSpecial to specify ho (ie
xlvalues?).

"Tom Ogilvy" wrote in message
...
CutCopyMode for sure - but that is usually what someone is doing when

they
copy in Excel.

--
Regards,
Tom Ogilvy

"Damien McBain" wrote in message
...
"Tom Ogilvy" wrote in message
...
It would be difficult. If performing an action causes an adverse
situation,
then the work around is to avoid the action. In this case, I think

you
might have to give something up. You are correct that many actions
performed by macros cause the clipboard to be cleared.

Does it clear the windows clipboard or just deactivate cutcopymode in

excel?