View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 2,069
Default my auto cell hiliting procedure kills copy/paste

I have the macro code below that follows the cursor and underlines the active
cell selection row to assist users. But this seems to kill any copy/paste
capability. Is there any easy way around this problem?

Cells.Borders.LineStyle = xlNone
ActiveCell.EntireRow.Borders(xlEdgeBottom).LineSty le = xlContinuous
ActiveCell.EntireRow.Borders(xlEdgeBottom).Weight = xlThick