"John A Grandy" wrote in message
...
how to capture a click event on a column header .... ?

Hi John,

You need to trap the SelectionChange event and then check the Target
range argument to see if it refers to an entire column.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"John A Grandy" wrote in message
...
how to capture a click event on a column header .... ?