enabling macros

G

Guest

I have created a custom macro with the outlook vba module
'thisoutlooksession', and whenever i try to come out of the design mode in
the vba editor i get the following error:

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.

I have set the security risk to low, but for some reason cannot run any
macros i have made.

I did try to make a com add-in, but there seesm to be something fatally
flawd with outlook's onAction command in CommandBarControl
 
G

Guest

Check under Help -> About Microsoft Office Outlook -> Disabled Items to see
if the VBA Add-In is listed, if so enable it. You also have to restart
Outlook after you change your macro security settings.

You may also want to sign your VBA project with a local security certificate
using selfcert.exe:

Visual Basic and VBA Coding in Microsoft Outlook:
http://www.outlookcode.com/d/vb.htm

In COM Add-Ins, a better approach is to declare CommandBar variables
WithEvents and run your code in the Click event rather than using OnAction.
 
G

Guest

I had already checked the security settings, and the disabled items, but to
no avail.
the selfcert seems to fail, whenever i try to save the project, it throws
'exception' errors, and doesnt save the certificate.

I would use a COM Addin, but cant find ANY source on the web to actually
help me do so. i can create the commandbar, and the button, but i cannot for
the life of me get a handle onto it, eith OnAction or Click.

Thankyou for your Help.
 
G

Guest

You might want to review this article to ensure that you followed the
procedure to sign the project correctly:

Code Signing Office XP Visual Basic for Applications Macro Projects
(Microsoft Office XP Technical Articles):
http://msdn.microsoft.com/library/en-us/dnoxpta/html/odc_dsvba.asp?frame=true

COM Add-Ins are powerful and the best way to automate Outlook, but require
an investment in effort. Everything you need to know is on this page:

Developing COM Add-ins for Microsoft Outlook:
http://www.outlookcode.com/d/comaddins.htm

--
Eric Legault (Outlook MVP, MCDBA, old school WOSA MCSD, B.A.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/
 

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