MS Office Add-In How-To

I collect here some useful resources and tipp to work with Microsoft Office Add-In i.e. customize Office Ribbon.

Customize Add-In Ribbon

Use http://www.andypope.info/vba/ribboneditor.htm

https://andypope.info/vba/ribboneditor_2010.htm 
Copy all 3 files in AddIn default directory %AppData%/Microsoft/AddIns

• Close .pptm file if open in Powerpoint (note the Macro function names you might want to set as Callback in the Ribbon)
• Open from Excel Ribbon: Developer->Ribbon Designer->Load RibbonX button.

Generate/ Update MS Office Add-In

• Check that .***m (.xlsm, .pptm) compiles
• Unload Add-In is already loaded from Developer->Add-Ins button.
• Save pptm as ppam/ or .xlsm as .xlam (Add-in) (Location %AppData%\Roaming\Microsoft\AddIns is automatically set by default after type selection)
• Reload Add-In from Developer->Add-Ins button

ImageMso

Useful resource: https://imagemso.codeplex.com/

Add-In Programming (VBA)

Alt+F11: to open Visual Basic Editor.