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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lose macros before saving 4
enable macros for trusted publisher 0
Macro security! 1
Access Issue, Macro Single Step, Error 3270 0
Macros won't run unless I open the VBA editor 2
Load Macros from xla on open 3
Digital signature breaks on insertion of new Worksheets 7
How to create a workbook from a signed addin that is itself signed 3

Back
Top