How do I intercept the user clicking on the ribbon header from the Toolbar

18 views
Skip to first unread message

will casey

unread,
Sep 15, 2021, 5:54:50 AM9/15/21
to Excel-DNA
Hi all,

I've recently created my first add in but have been asked to preload some data when the user clicks my custom ribbon from the toolbar rather than from individual buttons on my ribbon.

Any help would be great.

Thanks
Will


I've tried the AutoOpen event

 adding an onLoad  and commands to the customUI xml
        public override string GetCustomUI(string RibbonID)
        {
            return @"
              <customUI onLoad='Ribbon_Load' xmlns='http://schemas.microsoft.com/office/2006/01/customui'>
                    <commmands>
                            <command idMso='CopyFilesFromserver' onAction='CopyFilesFromserver'/>
                     </commmands>
              <ribbon>
                <tabs>.......
Reply all
Reply to author
Forward
0 new messages