Action Pane Disappear

Hi,

I have load a action pane to a Excel workbook, in the mean time, I double click another normal Excel file and then switch back to my VSTO Excel file. I found that the Action Pane disappeared.

How can I get it back (The action pane can't be appeared again even I press Ctrl+F1 in Excel 2003)

Thanks,


Answer this question

Action Pane Disappear

  • bcox

    Any comment on the following code

    //sheet1.cs
    // toggle DocumentActionTaskPane, can close it but not bring it back.
    private void button1_click(object sender, EventArgs e)
    {
    if (!this.Application.DisplayDocumentActionTaskPane)
    {
    this.Application.DisplayDocumentActionTaskPane = true;
    }
    else
    {
    this.Application.DisplayDocumentActionTaskPane = false;
    }
    }

  • ckara

    You can put it back programmatically using the ThisWorkbook_WindowActivate event. Just check the state of the DisplayDocumentActionTaskPane property:

    if (!ThisApplication.DisplayDocumentActionTaskPane)
    {
    ThisApplication.DisplayDocumentActionTaskPane = true;
    }


  • Langoti

    Thanks Dave, it works.

  • just another SSISy

    Once the visibility of TaskPane set to true, no matter you close it by clicking on X or Ctrl-F1, it will be always true, this could be a BUG.

  • Action Pane Disappear