Macro enabled Excel forms

[Ricco49]

I am trying to set up an Excel form for our angling club, with unlocked boxes on a protected sheet. I have added a command button to email the completed form back to me. However, when tested with one of the members they get a security message box because of the macro (obviously). Is there any way an IT illiterate (that is how he describes himself) is able to make this work, of anything I can do at the origin?



My thanks for any suggestions. I presume that somehow the form needs to be a trusted document.

[Logit]

.
https://www.amazon.com/clouddrive/sh...nSbDkC7TZiscyR


It usually occurs with the TRUST CENTER SETTINGS. Try the above steps.

[Ricco49]

Thanks, Logit. I found the settings (my Excel2010 is a bit different) and made the suggested alteration. Now to test it.