How to enable macros with protected worksheet

I have been trapped for hours of how to enable macros with protected worksheet.

Any suggestion please?

I did try to put UserInterFaceOnly on the vba code of that worksheet. But it still not working when I protected the worksheet.

Sub macroProtect3()

Sheet1.Protect Password:="abc" , UserInterFaceOnly:=True

Sheet1.Cells(1, 1) = UCase("hello")
'enter code

End Sub

Thank you very much in advance