greyangel
09-27-2017, 12:45 PM
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
ws.Protect Password:="Random", UserinterfaceOnly:=True, DrawingObjects:=True, Contents:=True, Scenarios:=True, _
AllowSorting:=True, AllowFiltering:=True