Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
XlBuiltInDialog.xlDialogPatterns
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.xlD ialogPatterns].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); |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
XlBuiltInDialog.xlDialogPatterns
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 "Laura Battarbee" wrote in 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.xlD ialogPatterns].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); | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
XlBuiltInDialog.xlDialogPatterns
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
XlBuiltInDialog.xlDialogPatterns
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 "Laura Battarbee" wrote in 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advice on Using "xlDialogPatterns" | Excel Programming |