Clever Geek Handbook

Outlook 2013 - VBA - Ribbon - onLoad not working

In %appdata%\Microsoft\Office\olkapptitem.officeUI

I have:

<?xml version="1.0" encoding="UTF-8"?>
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" onLoad="DoIt">
    <ribbon startFromScratch="false">
        <tabs>
            <tab idMso="TabMail">
                <group id="group1" label="Hazaa!">
                    <button id="one" onAction="DoIt2" label="hi" visible="true"/>
                </group>
            </tab>
        </tabs>
    </ribbon>
</customUI>

In Outlook, in a VBA editor, I have a module called Module1 that has:

Option Explicit

Sub DoIt(ribbon As IRibbonUI)
    MsgBox "hi"
End Sub

Sub DoIt2(control As IRibbonControl)
    MsgBox "bye"
End Sub

However, neither will be executed DoIt

, either DoIt2

. If I select options from DoIt2

, then when I click the button it starts, but not vice versa.

Any help is appreciated.

+3


source to share


1 answer


You cannot define ribbon callbacks in VBA. You need to develop an add-on if you want to customize the Ui ribbon using callbacks. Outlook, unlike any other Office application, does not support customizing the Ribbon UI with VBA.

The Ribbon UI is detailed in the following articles on MSDN:



+3


source






More articles:


All Articles