Problem running a macro in outlook

G

Guest

Hello!

I wrote a macro for outlook (in VBA), and added a button that runs the macro.
On my computer it works fine. I copied the file to a nother computer, and I
can see the code in the VBA editor. The problem is when I try to run the
macro.
The macro doesn't run! :(

Sometimes I get the following error message:

The macros in this project are disabled. Please refer to the online help or
documentation of the host application to determine how to enable macros.

How can I fix this???

Thanks,
Yonina.
 
K

Ken Slovak - [MVP - Outlook]

Low security can be dangerous to keep up other than for testing.

Office comes with an optional personal code signing certificate that you can
install and use by starting the selfcert.exe application. Once you create
your signature use it to sign your Outlook VBA code project and then trust
the signature so you can use a higher level of security without VBA being
disabled or being prompted for allowing macros on startup.

In the VBA code use Tools, Digital Signature to open the signature dialog.
Select your signature and OK using it. Save the VBA project and exit
Outlook. Restart Outlook and select Tools, Macro, Security. Make sure your
signature is listed in the Trusted Publishers tab. Then set your security
where you want it, you can even use High, then exit and restart Outlook
again and you should be all set from then on.
 

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

Top