This is not a setting that can be disabled/enabled.

I have never seen the warning box fail to appear when I have selected the entire
column unless there is a blank column between my selected column and the next
column with data.


Gord

On Tue, 2 Oct 2007 12:45:02 -0700, Legna105
wrote:

I have been trying to sort by selecting the entire column by header. I
believe another user has disabled the warning box. Any ideas on how to
re-enable it?

"Gord Dibben" wrote:

If you select the entire column by header you will get the Sort Warning dialog.

If you select just the top cell in the column Excel will automatically select
the current region with no warning.


Gord Dibben MS Excel MVP

On Tue, 2 Oct 2007 11:44:01 -0700, Legna105
wrote:

And the Sort Warning dialog box has been disabled somehow, so I can't click
"Continue with the current selection." Does anyone know how to re-enable the
sort warning dialog box?