Custom Filter that Displays All But in Ascending or Decending Orde

I have a worksheet that is password protected. The creator of the sheet
would like her users to be able to sort the data without unlocking the cells
(don't want others to edit the content) which is not possible in Excel. I
have tried recroding a macro to unprotect the sheet, perform a SORT and the
reprotect the sheet -- but the users are still prompted to enter a password
to unprotect the sheet.

The creator has also added an Auto Filter to the sheet which works while
protected. Is there a way to create a custom AutoFilter that will display
all entries in alphabetical order? -- similar to a sort?

Thanks. Kim

Good evening Kim

In short, no. But you were on the right lines by writing a macro that will unprotect the sheet, sort the contents and reprotect it. You just need to specify the password (in the example below, pword1) to Excel, thus:

ActiveSheet.Unprotect Password:="pword1"

and something like this to reprotect it:

ActiveSheet.Protect Password:="pword1"

HTH

DominicB

Do not know how to sort a Autofilter.

Why not change the macro so's it doesn't ask for a password?

Sub Sort_stuff()
ActiveSheet.UnProtect Password:="justme"

'your code to do the sorting

ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _
Contents:=True, Scenarios:=True, AllowFiltering:=True
End Sub


Gord Dibben Excel MVP

On Tue, 13 Sep 2005 14:28:18 -0700, Kim <[email protected]> wrote:

>I have a worksheet that is password protected. The creator of the sheet
>would like her users to be able to sort the data without unlocking the cells
>(don't want others to edit the content) which is not possible in Excel. I
>have tried recroding a macro to unprotect the sheet, perform a SORT and the
>reprotect the sheet -- but the users are still prompted to enter a password
>to unprotect the sheet.
>
>The creator has also added an Auto Filter to the sheet which works while
>protected. Is there a way to create a custom AutoFilter that will display
>all entries in alphabetical order? -- similar to a sort?
>
>Thanks. Kim

Thank you Thank you Thank you to both.

"dominicb" wrote:

>
> Good evening Kim
>
> In short, no. But you were on the right lines by writing a macro that
> will unprotect the sheet, sort the contents and reprotect it. You just
> need to specify the password (in the example below, pword1) to Excel,
> thus:
>
> ActiveSheet.Unprotect Password:="pword1"
>
> and something like this to reprotect it:
>
> ActiveSheet.Protect Password:="pword1"
>
> HTH
>
> DominicB
>
>
> --
> dominicb
> ------------------------------------------------------------------------
> dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
> View this thread: http://www.excelforum.com/showthread...hreadid=467269
>
>