Thank you for the link. It was very helpful.

"Gary''s Student" wrote:

This can be accomplished by using a Worksheet_SelectionChange macro. This
macro will run whenever a given cell is selected.

If you are not familiar with even macros, see:



http://cpearson.com/excel/events.htm
--
Gary's Student


"Dave" wrote:

I'd like to call a macro that sorts a list simply by clicking on a header cell.
Sort Key1 = the cell that the user clicks on.
Can one call a macro by clicking on a cell or the contents of a cell?
If so, how?
Thanks very much.