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

use your macro recorder,
then assign a button to the macro(forms toolbar,Button, draw button on
sheet)


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=522593

or just use the keyboard ALT - D(ata) - S(ort)


--
nsv
------------------------------------------------------------------------
nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500
View this thread: http://www.excelforum.com/showthread...hreadid=522593

Am sorry dave i dont seem to understand how to go about what you have said
could you please explain further???

"davesexcel" wrote:


use your macro recorder,
then assign a button to the macro(forms toolbar,Button, draw button on
sheet)


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=522593

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