Please click the # icon to insert code tags rather than quote tags for code.

That is because you did not add the password when you protected it. e.g.
Sheet2.Protect Password
I normally use ThisWorkbook's Open event to set the sheet's password with the UserInterfaceOnly option set to true. e.g.
Sheet1.Protect "ken", UserInterfaceOnly=True