I have to sort a protected sheet and need to perform the unprotect-sort-protect dance.
The problem is this way I'm duplicating (less than perfectly) Excel's own sorting functionality, with the predictable problems.
I've set the worksheet protected and selected to enable "Sort" on the "Allow users of this worksheet to" on the "Protect Sheet" window but this isn't working as expected.
I was thinking then to try pull up Excel's Sort dialog (see below). Is this exposed to us devs?