#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
.
https://www.amazon.com/clouddrive/sh...nSbDkC7TZiscyR It usually occurs with the TRUST CENTER SETTINGS. Try the above steps. |
#3
|
|||
|
|||
Thank you
Thanks, Logit. I found the settings (my Excel2010 is a bit different) and made the suggested alteration. Now to test it.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro Enabled Word Doc Does not Properly Work on Different Machine | danjoe | Word VBA | 3 | 10-19-2017 05:49 AM |
Enabling the undo function in a macro enabled workbook | jpb103 | Excel Programming | 4 | 06-05-2014 08:56 AM |
Word 2010 Macro Enabled Template with Content Controls | keen1598 | Word VBA | 7 | 01-29-2014 03:17 PM |
Saving as ( PowerPoint Macro-Enabled Slide Show )?? | delete123 | PowerPoint | 2 | 04-10-2013 05:38 AM |
Macro-enabled Template | ReviTULize | Word VBA | 4 | 02-01-2013 01:46 PM |