Hyperlink Sort

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top