I am new to macro, appreciate if anyone can guide me to my problems.

Kindly refer to the workbook link as below:
https://accapi.danahermail.com/seos/...fed74c36ebfdf1

1) If column F is "No", can column D & E be unprotected automatically? Vice-versa, if column F is "Yes", can column D & E be protected automatically?

2) Assuming column F is "No" and column D & E is unprotected automatically, after information are input in column D & E, can that particular cells be protected automatically so that no amendments are allow? (the rest of the unprotected cells are still in unprotect state)

3) Can macro start automatically every time I open the workbook?