Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Name Dialog parameters
I would like to programatically call the "New Name Dialog" box for a given
name. Microsoft.Office.Interop.Excel.Dialog D = ExcelApp.Dialogs[Microsoft.Office.Interop.Excel.XlBuiltInDialog.xlD ialogNewName]; D.Show(System.Reflection.Missing.Value, System.Reflection.Missing.Value ,System.Reflection.Missing.Value, System.Reflection.Missing.Value ,System.Reflection.Missing.Value, System.Reflection.Missing.Value ,System.Reflection.Missing.Value, System.Reflection.Missing.Value ,System.Reflection.Missing.Value, System.Reflection.Missing.Value .... ); Which of the many parameters to the Show() method corresponds to the [New] range name? Is there any thing I should do before passing the data in. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete the "Insert Function Dialog Box" (dialog box only)? | Excel Worksheet Functions | |||
How to permanently change Dialog Caption while in the Dialog | Excel Programming | |||
How to permanently change Dialog Caption while in the Dialog | Excel Programming | |||
How to record the EXCEL Solver Parameters Dialog Box? | Excel Discussion (Misc queries) | |||
control of dialog macro dialog box. on open | Excel Programming |