"The macro cannot be found" when clicking on the ribbon

[Paul_Hossler]

1. One of us is very confused

2. Based on the zipped customizations file, it looks like you're adding a macro named updatePropertiesCallback to the QAT (not the Ribbon):

<mso:cmd app="PowerPoint" dt="1" /><mso:customUI xmlns:macro="http://schemas.microsoft.com/office/2009/07/customui/macro" xmlns:mso="http://schemas.microsoft.com/office/2009/07/customui">
 <mso:ribbon>
  <mso:qat>
   <mso:sharedControls>
    <mso:control idQ="mso:FileNewDefault" visible="false" insertBeforeQ="mso:AutoSaveSwitch"/>
    <mso:control idQ="mso:FileOpenUsingBackstage" visible="false" insertBeforeQ="mso:AutoSaveSwitch"/>
    <mso:control idQ="mso:FileSave" visible="false" insertBeforeQ="mso:AutoSaveSwitch"/>
    <mso:control idQ="mso:FileSendAsAttachment" visible="false" insertBeforeQ="mso:AutoSaveSwitch"/>
    <mso:control idQ="mso:FilePrintQuick" visible="false" insertBeforeQ="mso:AutoSaveSwitch"/>
    <mso:control idQ="mso:PrintPreviewAndPrint" visible="false" insertBeforeQ="mso:AutoSaveSwitch"/>
    <mso:control idQ="mso:Spelling" visible="false" insertBeforeQ="mso:AutoSaveSwitch"/>
    <mso:control idQ="mso:SlideShowFromBeginning" visible="false" insertBeforeQ="mso:AutoSaveSwitch"/>
    <mso:control idQ="mso:PointerModeOptions" visible="false" insertBeforeQ="mso:AutoSaveSwitch"/>
    <mso:control idQ="mso:AutoSaveSwitch" visible="false"/>
    <mso:control idQ="mso:Undo" visible="false"/>
    <mso:control idQ="mso:RedoOrRepeat" visible="false"/>
    <mso:control idQ="mso:FormatPainter" visible="true"/>
    <mso:control idQ="mso:FontColorPicker" visible="true"/>
    <mso:control idQ="mso:BulletsGallery" visible="true"/>
    <mso:control idQ="mso:LanguageCommands" visible="true"/>
    <mso:control idQ="mso:ReviewNewComment" visible="true"/>
    <mso:control idQ="mso:SymbolInsert" visible="true"/>
    <mso:control idQ="mso:AnimationAddGallery" visible="true"/>
    <mso:control idQ="mso:ViewSlideMasterView" visible="true"/>
    <mso:control idQ="mso:MasterViewClose" visible="true"/>
    <mso:button  id="updateProperties" visible="true" label="updateProperties" imageMso="RecurrenceEdit" onAction="updatePropertiesCallback"/>
   </mso:sharedControls>
  </mso:qat>
 </mso:ribbon>
</mso:customUI>

You can call it a callback, but it really isn't; it's just the name of the macro, and AFAIK doesn't take parameters



3. So defining the macro's call like this is for ribbon controls (not customizations) and is the reason that the QAT button cannot find a macro in that PPTM

Option Explicit

Sub updatePropertiesCallback(control As IRibbonControl)
    MsgBox "test"
End Sub

4. Defined like this, the QAT icon does find the macro, and you could give it a more meaningful name like "updateProperties"

Option Explicit

Sub updatePropertiesCallback()
    MsgBox "test"
End Sub

Capture.JPG


5.

2. Can I use an absolute filename to a file containing macros I want to use in all presentations?

Make it an add in (PPAM file) and use 'ActivePresentation'. The macros are all in the add in