REMOVE SORT WARNING

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
 
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
 
Back
Top