Protection killed by sort button

[tykeinburton]

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.

 

[Norman Jones]

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"

 

[tykeinburton]

Thanks for that Norman, it works a treat

rgds

Martin