Hi Mary

Without using buttons, there is a absolutely superb method using invisible
rectangles, written by Dave Peterson and available as both code and a down
loadable file at Debra Dalgleish's site.

http://www.contextures.com/xlSort02.html#Pivot

and download Sortclick.zip


Regards

Roger Govier


Mary wrote:
I want to create buttons that will re-sort on different columns in the
spreadsheet. Does anyone have an example of this? Is it a marco I would use
to create the button and the function behind it?
Thank you.
Mary