How about an alternative?

Debra Dalgliesh has some code that allows you to click an invisible rectangle
floating over that column's header to sort by that column.

http://contextures.com/xlSort02.html


If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

lawmere wrote:

Hi ,

please i want to find out how i can create a command on a worksheet to sort
out data without necessarily having to go the the toolbar to do this? Please
help as its quite urgent.

regards

Lawrence

--

Dave Peterson