| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
| Accessing personal macro's all the time | Excel Programming | |||
| Accessing personal macro's all the time | Excel Programming | |||
| List Box and personal.xls | Excel Programming | |||
![Lenny_821[_22_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
