Read shapes in all worksheets in certain workbook and return list of macros assigned to each.
Needed as part of ANmar.systems 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 3,502
Downloads 1,443
CodeID
DB ID