thanks Bob. Thats just the ticket


"Bob Phillips" wrote in message
...
Just drag a button from the forms toolbar onto the worksheet and assign
your
macro to it.

Don't know the answer to the second I am afraid.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"elwyn" wrote in message
...
hi all

I know how to use the sort feature in excel XP and have a macro to sort
data
but is there anyway I can sort the data using a button/hyperlink/cell on
the
sheet itself?

As an aside, does anyone know why I can't see the posts I make to the
group
but I can see all the replies?

MTIA (again!)

elwyn