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.
Hans:
Appreciate the response.
The issue is clicking on Macros opens the dialogue box but there is no list of the macros . there are over 200 associated with the file.
Yes .. along with the List of macros being absent, the Ctrl + "letter" function doesn't work. I have numerous macros that are tied to a letter and that is also not working. Earlier versions of this file do not have either of these issues. I have had this problem before and have had to use an earlier version and rebuild it to incorporate the newer features contained in the problem version.
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.Thanks for the feedback!
