Put the following in a standard module:
Sub demo()
Columns("B:B").Sort Key1:=Range("B2"), Order1:=xlDescending,
Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End Sub
Sub ButtonMaker()
Set r = ActiveCell
ActiveSheet.Buttons.Add(177.75, 5.25, 36, 28.5).Select
Selection.OnAction = "demo"
r.Select
End Sub
The run the ButtonMaker macro. Macros are very easy to install and use:
1. ALT-F11 brings up the VBE window
2. ALT-I
ALT-M opens a fresh module
3. paste the stuff in and close the VBE window
If you save the workbook, the macro will be saved with it.
To use the macro from the normal Excel window:
1. ALT-F8
2. Select the macro
3. Touch Run
To remove the macro:
1. bring up the VBE window as above
2. clear the code out
3. close the VBE window
To learn more about macros in general, see:
http://www.mvps.org/dmcritchie/excel/getstarted.htm