Archive of Mr Excel Message Board

Try setting the worksheet's SelectionChange event to run the appropriate macro when the header cell is selected. If that causes inadvertent runs (e.g., when the cell is selected by cursor movement rather than by click), try the BeforeDoubleClick event and use a doubleclick to trigger the ranking. If you want a hyperlink, have the link go somewhere that the SelectionChange event can handle as a trigger for the ranking you want. The macro can return the cursor to wherever you would like it to be.