Excel 2010 Document Level Custom Task Pane

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

Excel 2010 Document Level Custom Task Pane
How to show 'per workbook' information in a Custom Task Pane in Excel 2007 and Excel 2010 
Alan Tolan




Posts: 8
Joined: 2016-04-15
We have an add-in that contains a Custom Task Pane (CTP). The information in the CTP is specific to the workbook (say, for example, we display some summary information about the workbook).

In SDI (2013 onwards) this works fine because we have a separate instance of the CTP for each document.
In MDI, we need to switch the contents of the CTP whenever we switch the active document and we would like the CTP to be blank when there is no workbook open.

I had a search through the documentation and forums and didn't find any guidance on how this might be done but I could have easily missed it.

Is there a recommended way on how this might be done?

Thanks,
Alan.
Posted 22 Jun, 2017 08:16:21 Top
Andrei Smolin


Add-in Express team


Posts: 14096
Joined: 2006-05-11
Hello Alan,

Put your controls on a UserControl. Put or not put that UserControl onto an instance of the task pane depending on the context in which the pane instance is shown.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 22 Jun, 2017 08:34:24 Top