Office Fee Sheet

The sheet that we have is working well except there are 2 things that keep coming up repeatedly we would like you to go into the trust settings so you change it that it trusts all the macros so it doesn't keep having the pop menu/box each time we open the sheet. The other issue is although we have cells locked we get the occasionally get #REF or #NAME?. The password to unlock the excel sheets is botox.