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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Calling up the macro dialog to list stored macros in a workbook-VB (https://www.excelbanter.com/excel-programming/385866-calling-up-macro-dialog-list-stored-macros-workbook-vbulletin.html)

mason

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

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

JLGWhiz

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

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 ?

All times are GMT +1. The time now is 01:42 AM.