Make Excel task pane visible and invisible programmatically

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

Make Excel task pane visible and invisible programmatically
 
Michael Hovdan




Posts: 37
Joined: 2010-06-26
I need to make my Excel task pane go invisible when the active workbook doesn't pass a certain "format validation test", and be visible when the user opens or creates a workbook that passes the test.

How can I do this?
Posted 01 Jun, 2015 12:39:59 Top
Andrei Smolin


Add-in Express team


Posts: 14111
Joined: 2006-05-11
Hello Michael,

Please see How to set the visibility of Advanced Excel Task Pane at https://www.add-in-express.com/support/delphi-excel.php.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 02 Jun, 2015 03:46:48 Top
Michał Głębowski




Posts: 42
Joined: 2015-06-08
I'm not sure if this is proper approach, but for me it works. I assume, you already:
a) created Panel (File->New->Other->Add-in Express VCL->ADX Excel Task Pane)
b) added TadxExcelTaskPanesManager to your AddIn
c) added item to collection of TadxExcelTaskPanesManager and properly set at least:
Position and TaskPaneClassName for that item to indicate your panel and be placed.

First I don't need Panel to be seen at start of Excel, so:

1) I put two lines in OnADXBeforeTaskPaneShow

Self.Visible := Tag = 1;
Tag := 1;

2) From Add-in I can now show or hide panel using simply

MYadxExcelTaskPanesManager.Items[0].TaskPaneInstance.Show; // or .Hide

Hope that helps.
Michal
Posted 30 Jun, 2015 15:02:47 Top
Andrei Smolin


Add-in Express team


Posts: 14111
Joined: 2006-05-11
Hi Michał,

That's a correct way of preventing the form from being shown at startup.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 01 Jul, 2015 02:43:09 Top