Macros not showing in pop-up.

When I go to run a macro, I no longer can see any in the pop-up. All of my macros are saved to my personal worksheet, and I've tried un-hiding that worksheet, selecting only the personal worksheet in the dropdown, and restarting both the program and the computer. I can see all of my macros when I open visual basic, in their normal locations, and I can run them from there, but it is extremely inconvenient to not be able to run them through the macro pop-up. Has anyone seen this before? Normally in the picture below there would be another 10 macros that would go something like "$PERSONAL!CleanupV2", "$PERSONAL!InsertAlternateRows", etc. I also attached a photo from visual basic which shows all of macros in my personal worksheet, they just won't show in the pop-up.

Are the modules/subroutines marked Private? Or do they require parameters?


Normally, a macro shows up in the macro list when you display the Macros dialog box (press Alt+F8), unless one of three conditions is met:

The macro is a function. Functions typically return information, and they require information to be passed to them. Since running a macro from the macro list doesn't allow either of these things to happen, Excel figures there is no need to list it. User-defined functions, which are quite useful in Excel, are not displayed in the Macros dialog box because they are, after all, functions.

The macro is a subroutine with parameters. Excel assumes that since parameters are necessary, and you cannot provide parameters by choosing the subroutine from the macro list, there is no need to list it.

The subroutine has been declared Private. This means that the subroutine is only useful to code within the module in which it is declared.

Courtesy: https://stackoverflow.com/questions/...in-macro-table

What has changed since 3PM yesterday?

When I reboot my computer, sometimes Windows "helpfully" updates itself. Any updates applied? I'm on Office 365, so it is constantly updating. What version do you have? I'm assuming 2302 is 365.