Read shapes in all worksheets in certain workbook and return list of macros assigned to each.
Needed as part of tools

Being in position where I inherit lots of tools from previous VBA programmers, where most of them are not very sophisticated, I needed to quickly tell which macro I need to focus on first, this tool allows me to start from macros that are ran by users.

' Open workbook needed to import its shapes (within same session of Excel) then run the tool from 'Shapes' sheet

Views 116 Downloads 51

Perm link