I have a macro (MacroThemeHandler) for updating the colour scheme of any given userform to a theme previously set by the user, but can't find a way to have it run whenever any other macro, particularly one with a userform, is run. I could go through and add a call to MacroThemeHandler into each of my many other macros, but is there a neater way of calling it? I've been looking into add-ins, but can't find any event that triggers when a macro is run. Any insight would be much appreciated. Thanks in advance.
