A List of Macro's

[Luc.Heyndrickx]

Hello,

How can I create a List of Macro's with VBA.

Thanks

Luc

 

[JE McGimpsey]

Search the archives:

http://google.com/advanced_group_search?q=group:*excel*

using the term "list of macros" and you'll find several ways, depending
on what you want to do with the list.

 

[Luc.Heyndrickx]

Thanks,

Here's the solution:
http://www.cpearson.com/excel/vbe.htm

Luc

 

[David McRitchie]

See to following topic on my Build Table of Contents page:

Subroutine and Function Table for Open Workbooks
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#ListFunctionsAndSubs

Goes a little beyond simply listing all the procedures and functions
it also identifies duplicates. As a subroutine with the same name in
one module as in another module withing same workbook or another
workbook such as your personal.xls -- also indicates how many lines
of code.

 

[Luc.Heyndrickx]

Thanx,

Luc

See to following topic on my Build Table of Contents page:

Subroutine and Function Table for Open Workbooks
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#ListFunctionsAndSubs

Goes a little beyond simply listing all the procedures and functions
it also identifies duplicates. As a subroutine with the same name in
one module as in another module withing same workbook or another
workbook such as your personal.xls -- also indicates how many lines
of code.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Hello,

How can I create a List of Macro's with VBA.

Thanks

Luc