You can use Me.Unprotect at the beginning of the code, and Me.Protect at the end of code. (will be protected without a password)

But you have to make sure you have the target cells unlocked to allow changes in the cells that can trigger the code. If no cells are editable and unlocked, the code will not be triggered.

If you want to set a password:

Me.Unprotect Password:="MySecretPassword"

Me.Protect Password:="MySecretPassword"

thank you

but it can not be used by multiple users?
can I use code for not share workbook and do something then share it again?