Tom

I am still getting the same error message (Unable to set the locked property of the range class) when I try and run the macro in my original spreadsheet. I cannot figure out what is wrong! Especially since the same code seems to work in another spreadsheet. The error appears to be with the range...locked=true portion of the code

Please help me

Ryan