I am using the macro below to protect a worksheet. I am able to filter but I am unable to sort. I wonder if this is due to the fact that it is a table? If I am right how can I correct that?
activeSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowSorting:=True, AllowFiltering:=True