Macro enabled Excel forms
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.
|