-
Excel VB Macros
I was just handed an Excel spreadsheet which contains 68 separate modules which hold about three times that many macros. Printed out, this is about 3/4" of paper!
I need to start digging through this code but it's kind of overwhelming with Excel's Alt+F8 setup. All I have is a list of Module numbers on the left column and no cross-reference as to what modules have what macros, or even what sheet they're called from. The Object Browser is a step in that direction, but it doesn't help much.
Is there a better tool to use for this? The "Project Explorer" and "Property Window" leave a lot to be desired.
------------------
The price of freedom is high.