software

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: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=522593
or just use the keyboard ALT - D(ata) - S(ort)--
nsv
------------------------------------------------------------------------
nsv's Profile: www.excelforum.com/member.php...oamp;userid=26500
View this thread: www.excelforum.com/showthread...hreadid=522593Am sorry dave i dont seem to understand how to go about what you have said
could you please explain further???

quot;davesexcelquot; wrote:

gt;
gt; use your macro recorder,
gt; then assign a button to the macro(forms toolbar,Button, draw button on
gt; sheet)
gt;
gt;
gt; --
gt; davesexcel
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=522593
gt;
gt;

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.

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

lawmere wrote:
gt;
gt; Hi ,
gt;
gt; please i want to find out how i can create a command on a worksheet to sort
gt; out data without necessarily having to go the the toolbar to do this? Please
gt; help as its quite urgent.
gt;
gt; regards
gt;
gt; Lawrence

--

Dave Peterson