Excel 2007 ribbon command RRS feed

  • Question

  • I have a simple xlam macro with a ribbon.

    In the customUI xml I have :

    <command idMso="SheetDelete" onAction="Command_Handler"/>

    This works fine, but the sheetdelete command always tries to run, even when the xlam isn't loaded - so whenever a worksheet is deleted, Excel loads the xlam file.

    If I rename my xlam file, Excel will crash, or throw a 400 error (with no further information).

    How can I have my xlam only override the sheetdelete command when the xlam is currently open in Excel?

    I thought any modifications to the ribbon were reset when the parent workbook/xlam was unloaded.

    Monday, February 24, 2014 10:52 PM