locked
Strange custom ribbon and macro name problem RRS feed

  • Question

  • Folks,

    I have recently helped a customer upgrade from Office 2003 to 2010, converting/updating macros and creating a custom ribbon.  One of the macros, named 'Email', who's sole function is to produce a new document based on a template, and contains no macros, produces a blank VBA dialog when the button is clicked on the custom ribbon.  The macro works perfectly when run directly!  If the macro is renamed to anything else, Email1, for example, and added to the custom ribbon, it runs perfectly!

    It seems there is some problem with a macro name Email, when added to a custom ribbon. BTW changing the button name or icon has no effect!

    Smells like a bug to me!

     

    Jon


    Jon
    Monday, June 20, 2011 11:34 AM

All replies

  • In Word 2007 a similar blank dialog is displayed if you create a macro named Email and add it to the Quick Access Toolbar!  Similarly if you rename the source macro without refreshing the custom ribbon or QAT, a blank dialog is displayed when you click the button!

    Jon


    Jon
    Tuesday, June 21, 2011 2:33 AM