REMOVE SORT WARNING

[Sally in KC]

I do a lot of sorting using the ascending and decending automatic sort keys
in Excel. I do NOT need the warning and am tired of having to answer the
idiot question many times a day. Can anyone tell me how to disable this
warning question?

Thanks,
Sally in KC

 

[Dave Peterson]

I don't think you can disable it.

I do a lot of sorting using the ascending and decending automatic sort keys
in Excel. I do NOT need the warning and am tired of having to answer the
idiot question many times a day. Can anyone tell me how to disable this
warning question?

Thanks,
Sally in KC

 

[Bernie Deitrick]

Sally,

You can use a macro assigned to a custom commandbar button instead of the automatic sort keys. For
example, to sort a table based on the activecell's column, you could use this:

Sub SortAscending()
ActiveCell.CurrentRegion.Sort _
Key1:=ActiveCell, _
Order1:=xlAscending, _
Header:=xlYes
End Sub

Of course, it would sort the entire block or table, and would use headers....

HTH,
Bernie
MS Excel MVP