Calling up the macro dialog to list stored macros in a workbook-VB

's Computer Specifications

How do u call the macro dialog, in code, to list all the macros that r saved
in a workbbook using Visual basic ?

's Computer Specifications

This is as close as I can get. I am sure there must be more that can be done.

Application.VBE.ActiveVBProject.Name = "TestProject"

"mason" wrote:

> How do u call the macro dialog, in code, to list all the macros that r saved
> in a workbbook using Visual basic ?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Drop down list using macros in a personal macros workbook	jlcoop01	Microsoft Excel Programming	0	23rd Oct 2009 03:56 PM
callin the macro dialog to list all stored macros in a workbook VB	=?Utf-8?B?bWFzb24=?=	Microsoft Excel Programming	1	22nd Mar 2007 05:34 PM
Call macro stored in Excel workbook from Outlook's macro	=?Utf-8?B?R3ZhcmFt?=	Microsoft Outlook VBA Programming	5	4th Oct 2006 06:26 AM
Calling macros in another workbook	=?Utf-8?B?TmljayBXcmlnaHQ=?=	Microsoft Excel Worksheet Functions	1	12th Jan 2006 04:03 PM
Calling macros from another XL Workbook	jamesa	Microsoft Excel Programming	1	2nd Oct 2003 03:06 PM