Re-enabling an Excel Task pane

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

Re-enabling an Excel Task pane
 
Richard Stevens


Guest


Hi - using ADX 2008 Pro in Delphi 7, I want to be able to turn an Excel task pane on or off through a button on a toolbar. I can turn it off OK through its Enabled property, but turning it back on doesn't do anything.

eg,

ExcelTaskPaneManager.Items[0].Enabled := not ExcelTaskPaneManager.Items[0].Enabled;

works for turning panes off, but not on again.

When I encountered a similar problem in Outlook you pointed me towards the ApplyTo method, but I can't find an equivalent in Excel?

Many thanks,
Richard Stevens
Posted 09 Feb, 2008 16:21:13 Top
Fedor Shihantsov


Guest


Hello Richard,

Use the following code: 
 
var
  taskPane: TadxExcelTaskPane;
begin
  adxExcelTaskPanesManager1.Items[0].Enabled := not adxExcelTaskPanesManager1.Items[0].Enabled;
  if (adxExcelTaskPanesManager1.Items[0].Enabled) then begin
    if adxExcelTaskPanesManager1.Items[0].TaskPaneInstance = nil then begin
      taskPane := adxExcelTaskPanesManager1.Items[0].CreateTaskPaneInstance;
      if (taskPane <> nil) then begin
        taskPane.Show;
      end;
    end;
  end;
end;
Posted 11 Feb, 2008 11:46:15 Top
Richard Stevens


Guest


Thank you Fedor - that works perfectly.

Excellent support, as always.

Richard
Posted 11 Feb, 2008 14:05:50 Top