Script To Call Workbook Macros

[Jaye7]

This may sound stupid as you can already do this via the toolbars, however.

Can anyone please provide a script that will call the macro popup list (list of all macros and then you can select which to run) as I want to activate it via a form that is in my workbook as I use different versions off excel on different computers and want to be able to call the popup list from my form, so I don't have to remember where it is in each version.

Thanks.

 

[MisterBate5]

Look in Excel Visual Basic help for dialogs object.

 

[Jaye7]

thanks misterbate but I am not that good with scripts and don't know what I am supposed to look for and how to use the script.

I searched through the dialogs options and only found the following script which bugs out.

Application.Dialogs(xlDialogMacroOptions).Show

Is there some other script that I should be looking for??????

 

[MisterBate5]

There's not another script you should be looking for, and I must admit I expected that the dialogs object would work. I just tried it and it doesn't work for me either.

Apologies, I don't know of another way you might be able to show the "Macros" dialog box.

 

[dave3009]

I think the code you're looking for is

Application.Dialogs(xlDialogRun).Show

This one here

Application.Dialogs(xlDialogMacroOptions).Show

requires you to name the macro as it shows the options for the particular macro, correct syntax being....

Application.Dialogs(xlDialogMacroOptions).Show ("MacroName")

 

[Jaye7]

Thanks Dave, exactly what I am after, your help is appreciated.