I am trying to figure out a macro that will allow users to sort data in ascending or descending order. I have tried the AllowSorting:=True, however that does not seem to work. I do have filters turned on automatically in the spreadsheet. Here is my current code below.
ws.Protect Password:="Random", UserinterfaceOnly:=True, DrawingObjects:=True, Contents:=True, Scenarios:=True, _ AllowSorting:=True, AllowFiltering:=True