Word addin not loaded when application is started with VBA from within Excel

Anonymous
2019-05-17T11:20:39+00:00

I have an add-in (dotm template) which is stored in Word's Startup folder. Among other things it contains a customized ribbon.

This works fine, no problems when Word is started from the menu, double clicking a document etc. The add-in is loaded and the customizations in the ribbon are visible.

However if Word is started from VBA within another application (Excel or Access) the customizations in the ribbon do not show. If I check in the Developer tab the Add-in is listed and is selected as well.

Even if I unselected it (unload) and select (load) it again from the interface, the customized ribbon does not show.

This worked fine in Office 2010 with the exact same Excel VBA code and the same add-in.

Why does it not work in Office 2016? 

Version 1904

Build 11601.20178

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

42 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-05-17T13:28:46+00:00

    Usually with Word problems safe mode is suggested but that does not address your problem. You could try renaming your normal.dotm file to see if that is the source of the problem.

    Does your Add-In modify the Ribbon using XML in the template or does it do it via vba?

    I am willing to work on this with you but would need your .dotm. I am not able to do much more today because I am due in court.

    If you want, save a sample document with the problem on OneDrive or Dropbox and paste a link here. Remove any confidential or sensitive information first. I or someone else can take a look at it.

    See https://answers.microsoft.com/en-us/windows/for...

    Was this answer helpful?

    0 comments
  2. Anonymous
    2019-05-17T13:19:15+00:00

    Hi Charles,

    Tried your code. Same result.

    Was this answer helpful?

    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  4. Anonymous
    2019-05-17T13:12:40+00:00

    Try my code and see what happens.

    Again, on my system, the Add-ins load and are active. The Ribbon modifications happen.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2019-05-17T13:06:17+00:00

    The problem is not that the code does not run, the problem is that the add-in that is in the startup folder is not loaded.

    The interface says its loaded (in tab Developer) but the ribbon customizations are not visible.

    Was this answer helpful?

    0 comments