I have a protected worksheet that has a form control button that performs a sort.

Here's the code:

Sub TestIt()
'
' TestIt Macro
'

'
   
    Range("O2:V80").Select
   
    ActiveWorkbook.Worksheets("Recipes").Sort.SortFields.Clear
    ActiveWorkbook.Worksheets("Recipes").Sort.SortFields.Add Key:=Range("P2:P80") _
        , SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
    With ActiveWorkbook.Worksheets("Recipes").Sort
        .SetRange Range("O2:V80")
        .Header = xlGuess
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
    End With
    
End Sub
The worksheet is protected. However when the user clicks on the button on the worksheet, the macro runs and performs the sort. Yes, all the cells in the sort area are locked.

Since the worksheet is protected, I would expect that when the user clicks on the button they should get a run time error. I do not want the user to be able to sort the sheet when the protection is on. Why is the macro executing?

Can someone help with the code so if the user clicks on the sort button they will get the run time error as expected.

Thanks for looking at this.