I am trying to make it so when my workbook opens, it protects the sheet, while allowing for filtering and sorting. The filtering works fine, but when I try to sort my list alphabetically, it doesn't work. The information on my sheet is for my company, so I can't share it, but I think my answer should be pretty simple. The following is the line of code I'm using for my function:
Sheets("Technicians").Protect Password:="3.14159", AllowSorting:=True, AllowFiltering:=True
Is AllowSorting not used to allow alphabetical sorting? I'm not sure where I'm going wrong
Bookmarks