Macros invisible to excel, but can be run from ribbon if already established, and appear in VBA editor

Question

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.

I tried to use a less-used macro button this morning called Unhide All Sheets and it threw this error:

Cannot run the macro 'PERSONAL.XLSB!UnhideAllSheets.UnhideAllSheets'. The macro may not be available in this workbook or all macros may be deleted."

So I went to review my code and all my macros are invisible from the front-end. I select Developer -> Macros, 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.

When I hit Alt + F11 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 Unexpected Error (35005) when run from the editor.

Anybody ever seen this before? I've been googling for an hour with no results.

Most Macro Buttons still work

Nothing on the Macro List

Customize Ribbon can't see the macros

Still visible and functioning in VBA Editor (except for "UnhideAllSheets")

question from:https://stackoverflow.com/questions/65833698/macros-invisible-to-excel-but-can-be-run-from-ribbon-if-already-established-an

Answer 1

Waitting for answers