Tracking border event
 

How could I track border drawing. Excel doesn't seem to generate this event.

--
Thanx & regards,
Asif

Tracking border event
 

Not the border per se, but for a chart there is a series change event. I am
trying to visualize how a border draw event would be used in a worksheet
range.

"Asif" wrote:

How could I track border drawing. Excel doesn't seem to generate this event.

--
Thanx & regards,
Asif

Tracking border event
 

I'm writing a row/col highlighter routine. The issue is that if a border is
drawn, Excel doesn't generate an event so I can't save the change as the
selection changes.
--
Thanx & regards,
Asif


"JLGWhiz" wrote:

Not the border per se, but for a chart there is a series change event. I am
trying to visualize how a border draw event would be used in a worksheet
range.

"Asif" wrote:

How could I track border drawing. Excel doesn't seem to generate this event.

--
Thanx & regards,
Asif

Tracking border event
 

There is a SelectionChange event for a worksheet. I haven't tried it so I am
not sure it would fire with a selection change by code. I know it fires with
a manual change. That could result in a lot of saving. It might be just as
efficient to put a save command in your code after the borders command has
executed.

"Asif" wrote:

I'm writing a row/col highlighter routine. The issue is that if a border is
drawn, Excel doesn't generate an event so I can't save the change as the
selection changes.
--
Thanx & regards,
Asif


"JLGWhiz" wrote:

Not the border per se, but for a chart there is a series change event. I am
trying to visualize how a border draw event would be used in a worksheet
range.

"Asif" wrote:

How could I track border drawing. Excel doesn't seem to generate this event.

--
Thanx & regards,
Asif