List of all Macro's in Personal.xls
 

Hi All,

I want to add a pop-up lisbox with all the macro's within my
Personal.xls.

How can I do that?

Lenny


--
Lenny_821
------------------------------------------------------------------------
Lenny_821's Profile: http://www.excelforum.com/member.php...o&userid=15179
View this thread: http://www.excelforum.com/showthread...hreadid=466188

List of all Macro's in Personal.xls
 

See Chip Pearson's site for sample code on working with the vbe:

http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy

"Lenny_821" wrote
in message ...

Hi All,

I want to add a pop-up lisbox with all the macro's within my
Personal.xls.

How can I do that?

Lenny


--
Lenny_821
------------------------------------------------------------------------
Lenny_821's Profile:
http://www.excelforum.com/member.php...o&userid=15179
View this thread: http://www.excelforum.com/showthread...hreadid=466188

List of all Macro's in Personal.xls
 

Lenny,

See the section "Listing All Procedures In A Module" at
www.cpearson.com/excel/vbe.htm . You can easily adapt that code
to look at all the module in a VBProject.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Lenny_821"
wrote in
message
...

Hi All,

I want to add a pop-up lisbox with all the macro's within my
Personal.xls.

How can I do that?

Lenny


--
Lenny_821
------------------------------------------------------------------------
Lenny_821's Profile:
http://www.excelforum.com/member.php...o&userid=15179
View this thread:
http://www.excelforum.com/showthread...hreadid=466188

List of all Macro's in Personal.xls
 

Thanks for the help :)

Lenny

--
Lenny_82
-----------------------------------------------------------------------
Lenny_821's Profile: http://www.excelforum.com/member.php...fo&userid=1517
View this thread: http://www.excelforum.com/showthread.php?threadid=46618