dialog box macros not working

[LFKim2018]

Instead of clicking Developer > macro to open macro dialog box (or pressing ALT F8),
I made a command button to open it by just one click (using the vba below),


Application.Dialogs(xlDialogRun).Show


the dialog box did pop up BUT the macros are not working! what could be the problem?
I am using excel 2013
many thanks

 

[Yongle]

Your code works with Excel2016 but runs the selected macro twice

Try this instead

    SendKeys "%{F8}"

 

[LFKim2018]

Your code works with Excel2016 but runs the selected macro twice

Try this instead

    SendKeys "%{F8}"

Mr. Yongle

It worked nicely..
many many thanks