In Excel, I can go to Developer->Macros to view all macros in open workbooks. I can then select to only show macros in the active workbook:
However, I often have multiple workbooks with lots of macros open at the same time. Choosing “This Workbook” allows me to view a less overwhelming set of macros and not have to look through as many. Is there a way to set this as default in Excel so it doesn’t always come up to “All Workbooks” and then I have to change it?
The answer on https://www.mrexcel.com/board/threads/excel-setting-to-default-to-this-workbook-in-macro-list.1176578/ simply says “not that I’m aware of.”
How to default Macros to run from This Workbook, NOT All Open Workbooks? is similar but didn’t really get a real answer.
https://www.reddit.com/r/excel/comments/erbsde/macro_button_list_is_there_a_way_to_view_the/ provided a super hacky VBA workaround that, by the user’s own admission, isn’t super reliable.
That’s basically all I was able to find online about it.
I’m on Excel 365 on a business device.
