Intercept the call to the toolbar "Sort" button...

[RASelkirk]

Hi All,

Not sure if this is doable, but I'd like to be able to run some user code (select range, adjust rowheight, cell color, etc.) when I click on the "Sort" button on the toolbar. Can this be done without an API call? Excel 2002 here...

Thanks!

Russ

[RASelkirk]

OK, so it's not possible to do this? I have since added a "sort" button with applicable code to each page, but that's kinda clunky looking...

Russ

[romperstomper]

Is there a reason for not just adding your own button to the toolbar instead?

[RASelkirk]

Is there a reason for not just adding your own button to the toolbar instead?

MERRY CHRISTMAS!

I ended up adding a button to each page (truthfully, I hadn't thought of a macro button), but will try that. Was only hoping to KISS at least as far as the interface goes...

Russ

[RASelkirk]

Thanks, RS! A much more elegant solution than having a button on each page...

Russ