MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Can you hyperlink a rank change


Posted by Robert Henderson on February 07, 2002 11:39 PM

Is there any way to rank a column by clicking on the title of that column?


Posted by Larry Kramer on February 08, 2002 5:35 AM

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.