Matt,

Take a look at http://www.cpearson.com/excel/vbe.htm. There is enough code
there to show you how.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Matt" wrote in message
...
Is there a way to programatically list all embedded macros
in a particular workbook? I need to access a workbook
object and update a listbox with all available macros.
thanks.