View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default event macros vs copy/paste

Hi,
XL2003
My manager asked me to draw a red line under the whole row of whatever cell
he selects, to make reading across the table easier on the eyes. I use a
change selection event to achieve this. But now, when he wants to copy and
paste, (which is ok), he can copy, but when he selects the paste cell, the
event macro runs and cancels the marching ants around the copied cell, and
the copied info is lost. Any solution to this?
Thanks in advance.
Dave.