Excel Ribbon - choose commands from macros disappeared

[Boffa]

Hi Guys,

Hoping for some help on this one.

I have a custom Tab on My Excel Ribbon titled 'Macros' - This has alot of my everyday macros I like to use that are saved in my personal workbook. - I have never had any issue adding macros to my custom tab on the Ribbon. However recently when I attempt to customize Ribbon and select Macros from the 'choose commands from' drop down, none of my personal macros are listed to select from.

Not sure if this is a setting that prevents me from seeing this ?

Has anyone experienced this before or now how to fix

Any help muchly appreciated

 

[Akuini]

Open Visual Basic Editor. Is there Personal.xlsb?

 

[Boffa]

Hi Akuini Yes I can see my personal.xlsb in the Visual Basic Editor

 

[Akuini]

Not sure what caused your problem, but maybe this helps:

Excel 365 macros disappeared...

OK...I've read hours online about this nightmare & here's what I've done & found out... 1) going to View > Macros...suddenly shows nothing 2) adding the "Developer" then going to "Visual Basic"...all macros are visible How in God's name can this be fixed. I've exported all modules & can't even...

www.mrexcel.com

 

[Boffa]

Yes that sounds very similar to my issue however that thread is yet to find a solution - Its so strange - Ive never had an issue with this before

 

[mastergrill]

The exact thing has just happened to me and been going through everything to try and figure out the issue.
Turns out I had a recent computer update which ticked the "Require Variable Declaration" box in the VBA > Tools > Options section
This was preventing all my macro's from being accessible in the customise ribbons drop down.
Just unticked the box and everything works again!

I know it's a while since this post was made but thought it'd be good to have a potential solution for anyone seeing it later on.