禁用Excel宏后CutomUI中的OnLoad无法回调导致报错怎么解决？

Question

XML代码如下，因为EXCEL报告分享出去时，查看的人有可能禁用了宏导致报错，我有两种思路，但不知道具体如何做：
1.是否能够在XML重解决这个问题，onload1无效时忽略错误。
2.VBAT中是否可以在输出报告时把用VBA代码把XML代码移除（手动都可以做，但是经常操作，所以想通过代码实现）

<?xml version="1.0" encoding="gbk" standalone="yes"?>
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="onLaod1" >
  <ribbon startFromScratch="false">
    <tabs>
      <tab id="mytab1" label="TEST" insertBeforeMso="TabHome">
        <group id="group1" label="Auto test">
          <button id="button1" label="Run" size="large" imageMso="BevelShapeGallery"  onAction="TEST_START_RIB" />
          <button id="button2" label="Stop" size="large" imageMso="BevelShapeGallery"  onAction="TEST_STOP_RIB" />
          <button id="button3" label="WaveTitle" size="large" imageMso="BevelShapeGallery" onAction="TEST_START_RIB" />
          <button id="button4" label="Index" size="large" imageMso="BevelShapeGallery" onAction="GenerateIndex" />    
        </group>
        <group id="group2" label="Device Configuration">
          <comboBox id="combo1" label="Oscilloscope" getImage="combo1IMG" getItemID="comboitid1" getItemLabel="combitlab1" 
            getItemCount="combitcou1" getItemSupertip="Supertip1" getText="combtext1" onChange="combots1"/>
          <comboBox id="combo2" label="Power1"  getImage="combo2IMG" getText="combtext2" onChange="combots2" />
          <comboBox id="combo3" label="Power2"  getImage="combo3IMG" getText="combtext3" onChange="combots3"/>
          <comboBox id="combo8" label="Power3"  getImage="combo7IMG" getText="combtext7" onChange="combots7"/>
          <comboBox id="combo4" label="Eloader1"  getImage="combo4IMG" getText="combtext4" onChange="combots4"/>
          <comboBox id="combo6" label="Eloader2"  getImage="combo5IMG" getText="combtext5" onChange="combots5"/>
          <comboBox id="combo7" label="Multimeter" getImage="combo6IMG"  getText="combtext6" onChange="combots6"/>
          <button id="button5" label="Connection" size="normal" imageMso="BevelShapeGallery" onAction="Connection_RIB" />
          <button id="button6" label="Disconnect" size="normal" imageMso="BevelShapeGallery" onAction="Disconnect_RIB" />
        </group>
        <group id="group3" label="Relay operation">
          <button id="RB1" label="mcpConfig" size="normal" getImage="buttIMG1"  onAction="RelayOnCtion" />
          <button id="RB2" label="VINLR" size="normal" getImage="buttIMG2"  onAction="RelayOnCtion" />
          <button id="RB3" label="VINHR" size="normal" getImage="buttIMG3"  onAction="RelayOnCtion" />
          <button id="RB4" label="Load" size="normal" getImage="buttIMG4"  onAction="RelayOnCtion" />
          <button id="RB5" label="Short" size="normal" getImage="buttIMG5"  onAction="RelayOnCtion" />
          <button id="RB6" label="EN" size="normal" getImage="buttIMG6"  onAction="RelayOnCtion" />
          <button id="RB7" label="VIN_OSC" size="normal" getImage="buttIMG7"  onAction="RelayOnCtion" />
          <button id="RB8" label="EN_OSC" size="normal" getImage="buttIMG8"  onAction="RelayOnCtion" />
          <button id="RB9" label="SW_OSC" size="normal" getImage="buttIMG9"  onAction="RelayOnCtion" />
          <button id="RB10" label="VIN_SENSE" size="normal" getImage="buttIMG10"  onAction="RelayOnCtion" />
        </group>  
      </tab>
    </tabs>
  </ribbon>
</customUI>

报错的提示：