View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default vba 2003 cut copy animated border

It sounds like something is clearing the cutcopymode in your code.

activesheet.range("c9:d13").copy

Turns on those marching ants for me.

But if I clear the clipboard with something like:
application.cutcopymode = false
(or even a different command that clears the clipboard), they disappear.


Jeff Higgins wrote:

I have implemented my own cut/copy paste operations on a particular worksheet.
I would like the border around my cut/copied selection to appear animated
(flashing, running) like the the border does when doing a standard cut/copy
selection operation. I've looked at the Borders property of the Range
collection and everywhere else I can think but cannot find a line style or
other property to set to make this happen.
Any help will be greatly appreciated.
Thanks,
Jeff Higgins


--

Dave Peterson