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