title: Quick Access Toolbar Customization: Selecting Macros causes Excel to crash
body: <p>Running Office '10 on Win7
  Experience: Some VBA experience, no XML experience</p>
  
  <p>Hi,
  I have two issues and an answer to the first may render the second mute.</p>
  
  <p>Q1) Is there a way to get macros in locked add-ins to show up in the QAT macros drop-down? For example, I am running Hyperion and the essexleqd.xla and essexcln.xll add-ins are running. At least some of the macros for these add-ins are visible in the QAT macros drop-down, even though the add-in itself is locked.</p>
  
  <p>Q2) Situation: Excel application is open, but there is no active/visible sheet open. When I go to customize QAT and then select macros from the drop-down, I get an error message and Excel crashes then restarts. Has anyone else encountered this, or know why this happens and has a fix?</p>
  
  <p>Background:
  I have a simple add-in that I want to distribute. I have locked it for viewing, but this means that I cannot create a QAT button that references the macro because the macro from the add-in is not visible in the QAT macros drop-down. I have read here (http://www.fontstuff.com/vba/vbatut03.htm) that this happens, but that I should be able to write in the name of the macro somewhere and the button will work. </p>