Double click event in protected sheet to trigger color change and value insertion

Hi Sir,

Still not working

Nothing happens when I double click. It works if Sheet1 is unlocked, but after that the sheet locks itself with the password in worksheet "pwdsheet B2" and nothing happens when I double click.

Ron