enabling macros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Neal Short - 07 Dec 2005 17:41 GMT

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

Reply to this Message

Eric Legault [MVP - Outlook] - 07 Dec 2005 22:08 GMT

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.

Signature

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/

> I have created a custom macro with the outlook vba module
> 'thisoutlooksession', and whenever i try to come out of the design mode in
[quoted text clipped - 8 lines]
> I did try to make a com add-in, but there seesm to be something fatally
> flawd with outlook's onAction command in CommandBarControl

Reply to this Message

Neal Short - 07 Dec 2005 22:17 GMT

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.

> 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
[quoted text clipped - 21 lines]
> > I did try to make a com add-in, but there seesm to be something fatally
> > flawd with outlook's onAction command in CommandBarControl

Reply to this Message

Eric Legault [MVP - Outlook] - 07 Dec 2005 22:27 GMT

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

Signature

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/

> I had already checked the security settings, and the disabled items, but to
> no avail.
[quoted text clipped - 32 lines]
> > > I did try to make a com add-in, but there seesm to be something fatally
> > > flawd with outlook's onAction command in CommandBarControl

Reply to this Message