Listing VBA Module-Subroutine titles

P

Peter Bernadyne

Does anyone know how I might be able to generate a report
in Excel (2000) which maps the module numbers for my
macros to their assigned subroutine titles? I'd like to
have such a mapping for reference so that I might easily
edit macros by going straight to the module I want.
Alternatively, is there anyway I can see my macros with
the titles I have assigned them rather than the module
number in the VBA explorer pane?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Excel 2003 - VBA to get a list of Module names in the project 4
New computer, how do i move outlook 365 ENTIRELY? 0
Cannot display Add-in Macro list without going to VBA/Project 5
VBA Macro Training in Chennai 0
ideas on how to make a test suite 3
Remove Protected Macro Code from Excel Module 4
Save copy on Open, keeping old backup copies 5

Top