You don't get an error protecting an already-protected spreadsheet. I just
tested that and that is not the problem. Since I can't run your code exactly
because I don't have your Userform, I don't know what might be causing the
problem, but you can always add an unprotect statement to an unprotected
sheet and not get an error. Try that and then I bet you won't get the error
again. And if you do get the error debug to see EXACTLY what line of code is
causing the error.