Forum Discussion
Developer + Macros doesn't produce a list of macros
From the ribbon: Selecting Developer and then Macros doesn't produce a droplist of the macros in the file.
Thanks for your PM. If you can see the macros in the Visual Basic Editor but not in the Alt+F8 Macro dialog, I don't know what causes it. I'd have to see a copy of the workbook to investigate it.
The VBA Code cleaner found the issue and fixed the file. While that is great, I don't know what it found or what it did to fix the problem. But here is a way to go about resolving this issue:
1. Go back to the previous version of the file that did not have the issue.
2. Compare work done in VBA in the current version (the one with the issue) to the earlier version.
3. The issue most likely is in a routine written in a Form's code.
4. VBA has a way of not compiling code with clearly unacceptable code and letting some minor issues slide, only to later complain and default on the same issue.
5. Comment out new work until the Macro Library is displayed in the ribbon as it should be when Developer is clicked and View Macro is clicked (or Alt + F8).
6. Anyone that has this issue is welcome to contact me and I'll explain first hand.
1. Go back to the previous version of the file that did not have the issue.
2. Compare work done in VBA in the current version (the one with the issue) to the earlier version.
3. The issue most likely is in a routine written in a Form's code.
4. VBA has a way of not compiling code with clearly unacceptable code and letting some minor issues slide, only to later complain and default on the same issue.
5. Comment out new work until the Macro Library is displayed in the ribbon as it should be when Developer is clicked and View Macro is clicked (or Alt + F8).
6. Anyone that has this issue is welcome to contact me and I'll explain first hand.
Thanks for the feedback!