List of all Macro's in Personal.xls

[Lenny_821]

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

[Tom Ogilvy]

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" <Lenny_821.1v36ee_1126260322.0698@excelforum-nospam.com> wrote
in message news:Lenny_821.1v36ee_1126260322.0698@excelforum-nospam.com...
>
> 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
>

[Chip Pearson]

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"
<Lenny_821.1v36ee_1126260322.0698@excelforum-nospam.com> wrote in
message
news:Lenny_821.1v36ee_1126260322.0698@excelforum-nospam.com...
>
> 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
>

[Lenny_821]

Thanks for the help

Lenny.