Creating a list of all macros in a workbook.
Posted on 2012-03-26
I would like to create a list of macros in my workbook, based on something like this:
Dim ListPos As Range, macroName As String
Set ListPos = cells([ListTop], 1).End(xlDown).Offset(1, 0)
ListPos = macroName
Of course, this may be not at all the way to go. But if it is, the two big questions are:
1) How do I define MacroName to be the name of each macro in succession
2) How do I set up the loop
i should be able to figure out the second one myself, but I can't.