Open Dialog Box Paste Special

S

Steven

How can you open the Paste Special dialog box and the Format Cells dialog box
by code?

Thank you,

Steven
 
J

JLGWhiz

Syntax is:

Application.Dialogs(<xlDialogsConstant>).Show

There is a list of the xlDialogsConstants in the VBA help files which you
can acces through the VB editor window.
 

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

Format Cells Dialog Box 3
Do File Open and default to the MyDocuments dialog box 4
Show the Paste Names dialog via code 3
User created Dialog Box 1
Suppressing dialogs 3
Excel 2003 - Save as dialog box 9
Open Macro Dialog Box 1
Excel wait for Find Replace dialog box in Word 4

Top