posting your code would help.
Macros do not respond to mouse clicks or other forms of
input divices. the code replaces all these. mouse clicks
can trigger code to run but they can't be used as code
parameters.
you might try in the code to sort by Activecell but i
have never tried that and am not too sure it would work.

-----Original Message-----
Hi,
I am working on a macro in Excel 2003 Pro, and everytime
I go to sort a
column of data. There are about 10 rows of data in about
200+ columns. I
can only get the macro to sort the column that I edited
it with. How can I
create the macro, so each time I click on the first row
of each column, click
the macro button I will assign to the toolbar, then that
row will be sorted,
and do this for each column?

Any help at all would be greatly appreciated,
Jeff Garrett )
.