unsigned VBA macros

  • Thread starter Thread starter Wendy
  • Start date Start date
W

Wendy

We're having a problem with one of our clients not being
able to load our VBA macro add-in (.xla) in Excel.
Coincidentally, they have MS AntiSpyware installed on
their machine. Could this be their issue? Our macro does
add selections to the Data menu.

Would digitally signing our macro solve this problem? If
so, is there a good site that'll help me learn how to
digitally sign a VBA macro? Thanks!
 
Wendy - I've answered this one in another group, where Ron Chamberlin also
answered.
 
In Excel, Tools menu, Macros, security, set it to medium.
Then she will get a prompt when she loads the file and she
can allow that maccro. As I remember it that prompt box
also includes a box to always trust, not sure.
 
Back
Top