Disabling the option to A-Z sort

[Spoursy]

Hi. I have a MS365 Excel workbook which is held in Teams and co-authored by a number of administrators. It is not password protected. Is there a way to disable to option of sorting A-Z whilst maintaining all other sort options? Thanks in advance

 

[SunnyAlv]

like this ? so all user can edit anything except sort

 

[SunnyAlv]

I don't think there's any way other than using complicated vba to do what you want.

View attachment 115010

 

[Spoursy]

Thanks - Would this still allow them to filter - but without the ability to sort - i.e the options below would show but 'Sort A-Z' and 'Sort Z-A' would not be available?