How to auto execute a macro when opening a Powerpoint presentation?

by

While Auto_Open doesn’t run in a PowerPoint presentation, you can fake it. Add a CustomUI part to the presentation, then use the CustomUI OnLoad callback to run code when the presentation opens. The CustomUI part needs no more than just the CustomUI tags.

Get the Custom UI Editor from here: http://openxmldeveloper.org/articles/customuieditor.aspx

Open the presentation in the Custom UI Editor. Insert a CustomUI part from the Insert menu:

Add a Custom UI part

Now enter some simple RibbonX code, like this:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" 
onLoad="MyOnloadProcedure" >
</customUI>

Now write your on-open procedure:

Sub MyOnloadProcedure()
    MsgBox "Hello"    
End Sub

If you have both this and the Auto_Open procedure in an add-in, Auto_Open runs first.

Full disclosure: while I thought of using this approach and have used it in Excel, I waited until I first encountered it on the PPT Alchemy web site: Run Code When PowerPoint Opens.

More Related Contents:

  1. Is it possible to declare variables procedurally using Rust macros?
  2. Can a Rust macro create new identifiers?
  3. Generating documentation in macros
  4. What makes Lisp macros so special?
  5. Macros in Swift?
  6. How can I generate unique values in the C preprocessor?
  7. How to prefix/suffix identifiers within a macro? [duplicate]
  8. Variadic recursive preprocessor macros – is it possible?
  9. How do I match the type of an expression in a Rust macro?
  10. How do I show the value of a #define at compile-time?
  11. Is there a way to count with macros?
  12. Can macros match against constant arguments instead of literals?
  13. How to allow optional trailing commas in macros?
  14. How to write macro for Notepad++?
  15. Mathematica: Unevaluated vs Defer vs Hold vs HoldForm vs HoldAllComplete vs etc etc
  16. How to embed a Rust macro variable into documentation?
  17. How to enforce that a type implements a trait at compile time?
  18. Are typedef and #define the same in c?
  19. How can I convert from degrees to radians?
  20. Preprocessor output
  21. Is there a macro recorder for Eclipse? [closed]
  22. What does #x inside a C macro mean?
  23. What does “#pragma comment” mean?
  24. Creating PowerPoint presentations programmatically
  25. How to generate random variable names in C++ using macros?
  26. MongoDB Failing to Start – ***aborting after fassert() failure
  27. Why should I avoid macros in C++? [closed]
  28. How to tame the Windows headers (useful defines)?
  29. How to auto-load MySQL on startup on OS X Yosemite / El Capitan
  30. When should I quote CMake variable references?

Leave a Comment