You didn't say, but have you gotten the code to work with the sheet
unprotected. If not, get it to work with the sheet unprotected, then attack
the protection problem.

Tom

This doesn't work even when I remove all the sheets' protections, in
the designer and at runtime, and I also removed all the cell locking.

Do you have any idea as to what could possibly prevent the
allowsorting value to always be false even when protection is
disabled?

Many thanks