Problem running a macro in outlook

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
Back
Top