VBA allow edit only when sheet is copied

[hajiali]

Hello All I have a sheet (Master) where I have protected with password were I do not want anyone to change or modify. However, when sheet is copied and named as "today's Date" I want it to be unprotected so that it is changeable and can be modified.

Perhaps when someone attempts to change "Master" sheet it prompts user to copy sheet first.

Any suggestions

 

[hajiali]

for anyone interested I was able to get it copied and unprotected and change to today's date using below code

Sub Copy_Unprotect_Sheet()    
    Sheets("MASTER").Select
    Sheets("MASTER").Copy After:=Sheets(10)
    Sheets("MASTER (2)").Select
    Sheets("MASTER (2)").Unprotect "PASSWORD USED"
    ActiveSheet.Name = Replace(Format(Now, "mm.dd.yyyy"), ":", "|")
End Sub