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:
Code:
ActiveSheet.Protect Password:="c"
DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowSorting:=True