Start ADXExcelTaskPane Hidden

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

Start ADXExcelTaskPane Hidden
 
Tim Overton


Guest


We're trying to convert from an ADXCustomTaskPaneInstance to an ADXExcelTaskPane and I cannot see any way to have the task pane hidden at start-up and only be displayed upon some action.

I have found a workaround where you set "Enabled" to false and then to display it I need set Enabled to true, call CreateTaskPaneInstance on the collection item and then call ShowTaskPane on the collection item too.

This seems very tedious and I feel like perhaps "I'm holding it wrong".
Posted 19 Nov, 2018 17:40:11 Top
Andrei Smolin


Add-in Express team


Posts: 18823
 Joined: 2006-05-11
Hello Tim,

To prevent the pane from showing, you should set ADXExcelTaskPane.Visible=false in the ADXExcelTaskPane.ADXBeforeTaskPaneShow event. Use a flag to let the form show: set the flag and call myADXExcelTaskPane1.Show().


Andrei Smolin
Add-in Express Team Leader
Posted 20 Nov, 2018 02:20:29 Top
Tim Overton


Guest


Thanks Andrei - that worked!
Posted 27 Nov, 2018 06:01:51 Top
Andrei Smolin


Add-in Express team


Posts: 18823
 Joined: 2006-05-11
Welcome!


Andrei Smolin
Add-in Express Team Leader
Posted 27 Nov, 2018 06:43:03 Top