Hyperlink Sort

[Guest]

Hello,

I am wondering if there is a way to set up a column label as a hyperlink,
and when that label is clicked, the table sorts by that label.

Any suggestions?

Thanks in advance.

AEROTJK

 

[Dave Peterson]

I don't think a hyperlink alone will be able to sort your data.

You could assign a macro to hidden rectangles in the header rows. The macro
would unprotect the sheet (if required), sort by that column and reprotect the
sheet (if required).

If you like that idea, you could start at Debra Dalgleish's site:
http://www.contextures.com/xlSort02.html

 

[David McRitchie]

I would use an Event macro such as double-click
http://www.mvps.org/dmcritchie/excel/event.htm