XlBuiltInDialog.xlDialogPatterns

[Laura Battarbee]

I am trying to show the format shape dialog in Excel 2007 programatically
when a line is selected, but the below code does not show the form or throw
an exception either, anyone have any ideas?
I have tried setting screen updating to true.


Microsoft.Office.Interop.Excel.Line object it selected

Application.Dialogs[Microsoft.Office.Interop.Excel.XlBuiltInDialog.xlDialogPatterns].Show(missing,
missing, missing, missing, missing, missing, missing, missing, missing,
missing, missing, missing, missing, missing, missing, missing, missing,
missing, missing, missing, missing, missing, missing, missing, missing,
missing, missing, missing, missing, missing);

 

[Jim Rech]

I know zero about 'interop' but the VB equivalent works:
Application.Dialogs(xlDialogPatterns).Show

Have you had success showing any built-in dialog? I mean, are you sure it's
possible?

--
Jim
message |I am trying to show the format shape dialog in Excel 2007 programatically
| when a line is selected, but the below code does not show the form or
throw
| an exception either, anyone have any ideas?
| I have tried setting screen updating to true.
|
|
| Microsoft.Office.Interop.Excel.Line object it selected
|
|
Application.Dialogs[Microsoft.Office.Interop.Excel.XlBuiltInDialog.xlDialogPatterns].Show(missing,
| missing, missing, missing, missing, missing, missing, missing, missing,
| missing, missing, missing, missing, missing, missing, missing, missing,
| missing, missing, missing, missing, missing, missing, missing, missing,
| missing, missing, missing, missing, missing);
|

 

[Laura Battarbee]

Thanks Jim.

Tried it in VBA too...

With a line object selected I am able to run the code
"Application.Dialogs(xlDialogPatterns).Show" in Excel 2003, but in Excel 2007
the line of code does nothing.

I think the dialog box has changed between the versions. For example in
2003 the dialog box has the title "Format AutoShape" whereas in 2007 it says
"Format Shape" and has a lot more going on in it (has the line style tab
selected).

Anyone know how to call the 2007 dialog box?

 

[Jim Rech]

but in Excel 2007 the line of code does nothing.

Not so for me. With a line selected I get the "Format Object" dialog which
appears to be the same thing as the "Format AutoShape" dialog in Excel 2003.


--
Jim
message | Thanks Jim.
|
| Tried it in VBA too...
|
| With a line object selected I am able to run the code
| "Application.Dialogs(xlDialogPatterns).Show" in Excel 2003, but in Excel
2007
| the line of code does nothing.
|
| I think the dialog box has changed between the versions. For example in
| 2003 the dialog box has the title "Format AutoShape" whereas in 2007 it
says
| "Format Shape" and has a lot more going on in it (has the line style tab
| selected).
|
| Anyone know how to call the 2007 dialog box?