How to Create Excel Pane Programatically

Add-in Express™ Support Service
That's what is more important than anything else

How to Create Excel Pane Programatically
How to show disabled Task Pane in Excel 
George Spears




Posts: 79
 Joined: 2010-05-06
Hello,

I have created a plugin for Excel with a single task pane. The task pane shows when I start Excel. I do not want this behavior. I have create a Ribbon based menu to show the pane.
I go into ExcelTaskPanesManager and set Enabled = False; IT no longer shows at startup.

My problem is .. How do I show it now?

I am using the following code from a menu button, and while it runs, the pane is not displayed.
I have tried MULTIPLE procedures... Show, Enabled, Activate, etc.... 

var
  ExcelPane: TadxExcelTaskPane;
begin
  ExcelPane := adxExcelTaskPanesManager1.Items[0].TaskPaneInstance as TadxExcelTaskPane;
  if ExcelPane = nil then
  begin
     ShowMessage('Creating Pane');   // This does display
    ExcelPane := adxExcelTaskPanesManager1.Items[0].CreateTaskPaneInstance;
    ExcelPane.Enabled := True;
    ExcelPane.Visible := True;
    ExcelPane.Show;
    ExcelPane.Activate;
    ShowMessage(IntToStr(ExcelPane.Height));  // This shows as 515
  end
  else
  begin
    ShowMEssage('Showing Pane');
    ExcelPane.Show;
    ExcelPane.Visible := True;
  end;

Thanks,
GSpears
Posted 22 Feb, 2012 08:52:01 Top
George Spears




Posts: 79
 Joined: 2010-05-06
Never mind.. Solution is here...
http://www.add-in-express.com/forum/read.php?FID=1&TID=3045
Posted 22 Feb, 2012 09:09:49 Top