Disable Sorting in Excel?

0 ⤊

Disable Sorting in Excel?

I need to disable sorting in Excel preferably using VBA

Does anyone know if it's possible and how to do it.

I need to diable sorting on a worksheet due to the fact that the data is being messed up and not corresponding.

How do I disable a whole worksheet or a column

2007-02-14 00:00:34 · 2 answers · asked by per4more 3 in Computers & Internet ➔ Programming & Design

2 answers

The simplest way to lock out sorting is to turn sheet protection on. First, select the cells where users are allowed to enter data. Go to format/cells/protection/unclick lock cells.
Turn protection on using tools/protection/sheets before you distribute your spreadsheet.

2007-02-14 13:37:07 · answer #1 · answered by unnga 6 · 0⤊ 0⤋

please look at the top op page in excel

2007-02-14 00:06:53 · answer #2 · answered by esmalaliblack 1 · 0⤊ 0⤋