Yeah, I agree; I wasn't able to find any event that might be triggered by resizing columns either.
There's nothing wrong with triggering it via the Selection_Change event, as far as I can see, but if you want to get fancy you could use Worksheet_BeforeDoubleClick. That way it isn't invoked every time you move the cursor or innocently click on a cell; it runs each time you double-click on a cell. That means you have to work a little harder to invoke the program, but by the same token it means it isn't running as often when not needed. Just a thought, not necessarily a recommendation.
|