Mar 13 2021 09:01 AM
From the ribbon: Selecting Developer and then Macros doesn't produce a droplist of the macros in the file.
Mar 13 2021 09:15 AM
Clicking Developer > Macros shouldn't produce a dropdown list but open the Macro dialog:
Mar 14 2021 07:58 AM
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.
Mar 14 2021 08:10 AM
Have you selected the correct workbook or 'All Open Workbooks' from the 'Macros in' dropdown?
Mar 14 2021 08:20 AM
Mar 14 2021 08:45 AM
Mar 14 2021 09:11 AM
Are you absolutely sure that the macros are stored in that workbook?
Can you see them in the Visual Basic Editor?
Mar 14 2021 01:23 PM
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.
Mar 15 2021 04:06 PM
Mar 16 2021 03:52 AM
Thanks for the feedback!