RS

Even in later versions of Excel there are restrictions on filtering and sorting
that must be overcome.

The Protect Sheet dialog gives you a number of options to choose from, but
autofilter must be enabled before protecting the sheet.

Sort will only work on rows in which all cells in the range of rows are
unprotected.

Most everybody winds up with code to unprotect, sort, then re-protect.


Gord Dibben MS Excel MVP

On Tue, 31 Oct 2006 21:58:02 -0800, RS wrote:

Regarding the macro, since the number of rows needing to be sorted would be
constantly changing, sounds like it might be easier to find a later version
of Excel and then simply resave my spreadsheets using the new versions
ability to simply select a check box to allow sorting and autofiltering.