While waiting for the developers to comply, do you want a single-click on a
button macro that sorts only the selected column?

Sub sort_selected_column()
Dim srng As Range
Set srng = Range(ActiveCell, Cells(Rows.Count, _
ActiveCell.Column).End(xlUp))
srng.Sort Key1:=Range(srng.Cells(2).Address), _
Order1:=xlAscending, Header:=xlYes, _
OrderCustom:=2, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End Sub


Gord Dibben MS Excel MVP


On Tue, 2 Feb 2010 12:46:08 -0800, dkat
wrote:

I am doing 3 clicks where I should only have to do one so it is increasing my
work time 200% (actually more because I then have to move the mouse to the
right area to click) and it is driving my nuts (not to mention playing havoc
with my arthritis). I have dozens of columns that each have to be sorted
indepently and to not be able to turn this annoying prompt off is making me
want to find other software.

"mzehr" wrote:

This is just a suggestion to MS. Feel free to add your opinion if you wish.
Excel should offer a feature to allow experienced users to disable the sort
warning in Excel 2003 that pops up everytime you select a range that has info
in any of the cells contiguous with that range.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc