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

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

AEROTJK wrote:

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 would use an Event macro such as double-click
http://www.mvps.org/dmcritchie/excel/event.htm

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"Dave Peterson" wrote in message ...
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

AEROTJK wrote:

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