Allow sorting in a protected sheet

[Src016]

Hi all,

I need to allow sorting in an unlocked table within a protected sheet. I have enabled filtering, but for some reason sorting is an issue. Every time I try and sort I'm prompted with "The cell or chart you're trying to change is on a protected sheet. To make a change, protect the sheet. You might be requested to enter a password." The code I use to protect the sheet is below. The allow filtering works, but I'm having an issue with the allow sorting. I would like to avoid this, but I could write code that unlocks the entire sheet if the topline of the taple (row 18) is selected. This would allow sorting then re-lock the sheet. Any suggestions would be greatly appreciated!

ws.Protect wsSettings.Range("Settings_Password"), AllowFiltering:=True, AllowSorting:=True

 

[kweaver]

You'll need to remove the password in the VBA code and then sort and then reset the password. Then, save the VBA with a password so that a knowledgeable user can't find the password in the VBA code.