VBA Excel 2007 Changing Protection Parameters

I am using macros with a worksheet that is protected. I unprotect it and run the macro, but when I try to re-protect it, my parameters are reset. I have tried writing the code to specify the parameters, but I receive a syntax error. Here is my protection code:

Please Login or Register  to view this content.

I solved the original problem, but it created a new one: the sheet would be left unprotected. I solved that problem and got the sheet to be protected, but then it would not allow the data to be sorted, even though sorting is allowed in the code. Here is what I have so far:

Please Login or Register  to view this content.