sort - protected sheet

[wmtsub]

I am protecting a sheet and allowing sorting and auto filter. But when I try to sort it says the sheet is locked.
Is this code wrong?


ActiveSheet.Protect Password:="123", DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowSorting:=True, AllowFiltering:=True

 

[Joe4]

Note what it says here, regarding the "AllowSorting" argument: https://docs.microsoft.com/en-us/office/vba/api/excel.worksheet.protect
specifically:

[FONT=&quot]Every cell in the sort range must be unlocked or unprotected.[/FONT]

If it is not, then you must unprotect the sheet, sort, then re-protect the sheet.