event macros vs copy/paste

D

Dave

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.
 
D

Dave

Hi Chip,
Thanks for that. I'd rather not use an add-in if I can aviod it, but will
consider that if no other solution is suggested.
Regards - Dave.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top