View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Laura Battarbee Laura Battarbee is offline
external usenet poster
 
Posts: 6
Default 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);