Way to Get Around Macros Not Working in Protected Sheet?

Hi,

Is there a way to get around macros not working in a protected sheet? I want to allow user to enter multiple responses using the following code, but it won't work if sheet is protected.

Sub mymacro()
     
    ActiveSheet.Unprotect ("lfw")
     
    'your code here
     
    ActiveSheet.Protect ("lfw")
     
End Sub

Is there a code I can use to override the disabling of macro when I protect sheet? I want to protect sheet so users don't accidentally change codes, field titles, lists, etc....

Thanks,
Lyndy


Moderators note: code tags added for you - this time