Tracking border event

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Asif - 23 Nov 2007 14:51 GMT

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

Signature

Thanx & regards,
Asif

Reply to this Message

JLGWhiz - 23 Nov 2007 15:13 GMT

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.

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

Reply to this Message

Asif - 23 Nov 2007 15:49 GMT

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.

Signature

Thanx & regards,
Asif

> 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.
>
> > How could I track border drawing. Excel doesn't seem to generate this event.

Reply to this Message

JLGWhiz - 24 Nov 2007 19:29 GMT

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.

> 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
[quoted text clipped - 5 lines]
> >
> > > How could I track border drawing. Excel doesn't seem to generate this event.

Reply to this Message