I think I have mentioned this before that the AllowSorting option seems to just enqable or disable the Sort button, it doesn't actually allow you to sort the data (real genius that thought up that combination!).
You need to unprotect it in VBA, sort it, then protect it again.
My cells are only hidden not protected but I still can't get it to work.
Originally Posted by xld
Posting Permissions
Reply With Quote