Does anyone know how I can protect a worksheet from being renamed by
the user without stopping him/her from amending (or adding) values to
that worksheet?

All I want to do is to stop renaming!