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.
Clicking Developer > Macros shouldn't produce a dropdown list but open the Macro dialog:
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.
- 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.
Are you absolutely sure that the macros are stored in that workbook?
Can you see them in the Visual Basic Editor?
Have you selected the correct workbook or 'All Open Workbooks' from the 'Macros in' dropdown?
