Hi TykeInBurton,

I am able to replicate your experience in xl2000.

In your button code try something like:

Application.Dialogs(xlDialogSort).Show
ActiveSheet.Protect UserInterfaceOnly:=True, _
Password:="ABC"

---
Regards,
Norman



"tykeinburton" <tykeinburton@yahoo.co.uk> wrote in message
news:1131015992.774298.205450@o13g2000cwo.googlegroups.com...
> Hi, I am working in Excel 2000.
>
> I have a spreadsheet with one worksheet protected on open with
> userinterfaceonly set to true to allow users to use the autofilters.
>
> Users also need to use the sort function, so I have created a button
> which simply calls the excel sort dialogue box. But when ok is pressed
> on the dialogue box the protection on the worksheet has been removed.
>
> Can anyone explain why this is happening, and suggest how to resolve
> the issue, as we need the protection in place to prevent accidental
> loss of data.
>
> Thanks
>
> Martin.
>