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

G

Guest

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

Guest

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

Application.VBE.ActiveVBProject.Name = "TestProject"
 

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

callin the macro dialog to list all stored macros in a workbook VB 1
Run code from another workbook 7
How to force macros refer to ActiveWorkbook 2
How to call Excel add-in macro from a button… 1
Unwanted workbooks on startup 2
VB macros in new Excel 24
Clearing Macros from Workbook 4
macros in my custom xla Addin - how to make visible in Macro menu? 2

Top