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

Task Information Dialog Box not making duration changes to task 0
Deleting a Profile 1
Accessibilty - how to open doc with keyboard? 0
Insert Multiple Fields without Dialog closing between each... 0
Create a dynamic master file 1
Fixing attributes special paste 1
macOS Office365 Word 0
Format Cells Dialog Box 3

Top