Open a dialog box

  • Thread starter Thread starter ChelseaWarren
  • Start date Start date
C

ChelseaWarren

I've done this before but don't remember how ... I need a script that will
open a particular dialog box and then stop.

Can anyone help?

Thanks so much!
 
Perhaps you are looking for something similar to:
application.dialogs(xlDialogSaveAs).show
which shows the saveas dialog box. modify to show whatever dialog box you
actually want.
 
Thank you. That's exactly it!

JMB said:
Perhaps you are looking for something similar to:
application.dialogs(xlDialogSaveAs).show
which shows the saveas dialog box. modify to show whatever dialog box you
actually want.
Click to expand...
 
You must log in or register to reply here.

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

Marco to open the "Customer Auto filter dialog box" 4
Dialog Box Buttons 1
Excel 2003 - Save as dialog box 9
Open Folder dialog box 3
Open Dialog Box Paste Special 2
User created Dialog Box 1
Macro to launch the Activate dialog box? 2
How disable an Excel dialog box? 4

Back
Top