View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Open Macro Dialog Box

Hi Steven,

Try:

Application.Dialogs(xlDialogRun).show


---
Regards,
Norman



"Steven" wrote in message
...
Alt + F8 will open the Macro dialog box.

How can I automate the Alt+F8 in a macro so the macro will
open the macro dialog box.

Thank you,

Steven