title: Macros invisible to excel, but can be run from ribbon if already established, and appear in VBA editor
body: <p>I have some macros attached to buttons in the Quick Access Ribbon. All but one of the buttons have been functioning normally, so I'm not sure when this started.</p>
  <p>I tried to use a less-used macro button this morning called <code>Unhide All Sheets</code> and it threw this error:</p>
  <blockquote>
  <p>Cannot run the macro 'PERSONAL.XLSB!UnhideAllSheets.UnhideAllSheets'.  The macro may not be available in this workbook or all macros may be deleted.&quot;</p>
  </blockquote>
  <p>So I went to review my code and all my macros are invisible from the front-end. I select <code>Developer -&gt; Macros</code>, the list is completely empty, and when I attempt to create new buttons on the Quick Access Toolbar, the macro list there is also completely empty.</p>
  <p>When I hit <kbd>Alt</kbd> + <kbd>F11</kbd> to open the VBA editor, I can see and update macros in specific workbooks and in my personal workbook.  Most of them still run, although the offending macro (UnhideAllSheets) throws an <code>Unexpected Error (35005)</code> when run from the editor.</p>
  <p>Anybody ever seen this before?  I've been googling for an hour with no results.</p>
  <p><strong>Most Macro Buttons still work</strong>
  <a href="https://i.stack.imgur.com/QSCkc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QSCkc.png" alt="enter image description here" /></a></p>
  <p><strong>Nothing on the Macro List</strong>
  <a href="https://i.stack.imgur.com/2X8yD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2X8yD.png" alt="enter image description here" /></a></p>
  <p><strong>Customize Ribbon can't see the macros</strong>
  <a href="https://i.stack.imgur.com/FND3I.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FND3I.png" alt="enter image description here" /></a></p>
  <p><strong>Still visible and functioning in VBA Editor (except for &quot;UnhideAllSheets&quot;)</strong>
  <a href="https://i.stack.imgur.com/1oI0X.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1oI0X.png" alt="enter image description here" /></a></p>