How to reference a function from another .dotm file in Word custom ribbon XML?

hank1234 · #1 08-11-2024, 05:09 AM

I'm customising Word with two template files: Ribbon.dotm and StyleManager.dotm, and I'm facing a specific issue with XML referencing.

Setup:

Ribbon.dotm: Contains XML for custom ribbon and most of the VBA code
StyleManager.dotm: Contains a specific module/userform I want to access
Both .dotm files are in Word's startup folder
All code is present and functional, and the naming of .dotm files and subroutines is correct

The Issue:

XML in Ribbon.dotm defines buttons, most calling functions within Ribbon.dotm successfully
One button should call a function from StyleManager.dotm
The problem lies specifically in how to correctly reference a function in another .dotm file within the XML

When clicking the button that should call the StyleManager.dotm function, I get this error: "The macro cannot be found or has been disabled due to your macro security settings."

Here's the relevant part of the XML code where the issue occurs:

Code:

onAction="StyleManager.dotm!mStyleManager.ShowfrmParagraphStylesIfNecessary"/

The key question is: What is the correct XML syntax to reference a function in StyleManager.dotm from within Ribbon.dotm's XML?

Is there perhaps an alternative method to create a single Ribbon that incorporates buttons from multiple .dotm files? While I'm aware that the simplest solution would be to migrate the code from StyleManager.dotm into Ribbon.dotm, I'm particularly interested in exploring whether it's feasible to maintain the current file structure while achieving the desired functionality. Are there any advanced techniques or workarounds that could allow for this kind of cross-file referencing in the Ribbon XML?

This is the full XML code:

Code:

<?xml version="1.0" encoding="UTF-8"?>
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
  <ribbon startFromScratch="false">
    <tabs>
      <tab id="Company" label="Company">
        <group id="newGroup" label="New">
          <menu id="mnuMemo" 
                size="large" 
                label="Memo" 
                imageMso="NewPageOneNote">
            <button id="btnCreateMemo" 
                    label="New memo" 
                    onAction="mMemo.CreateNewMemo"/>
            <button id="btnEditMemo" 
                    label="Edit memo" 
                    onAction="mMemo.EditMemo"/>
          </menu>
          <!-- Button attempting to call function from StyleManager.dotm -->
          <button id="btnStyleManager" 
                  label="Paragraph Styles" 
                  onAction="StyleManager.dotm!mStyleManager.ShowfrmParagraphStylesIfNecessary"/>
        </group>
      </tab>
    </tabs>
  </ribbon>
</customUI>

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
instance a new dotm file from a Word dotm file and save with new file name	David Peck	Word VBA	3	08-18-2023 06:47 AM
Dissociate instance of a custom ribbon, for documents based on the same dotm creation template?	Ddadoo57	Word VBA	7	03-21-2023 05:34 AM
Word Custom Ribbon In .dotm - How to edit/create?	s0me0nesmind1	Word	6	04-16-2020 04:10 PM
Custom ribbon button or shortcut for a specific function	Nicobisgaard	Word	6	04-22-2015 04:39 AM
Is it possible to add a custom macro button to the FILE tab of the ribbon in excel	sbapabck	Excel	2	04-11-2014 07:36 AM