I'm showing a custom task pane in an excel VSTO add-in, I'm building it and showing it as thus:
var ctrl = new CellTaskPane();
var pane = CustomTaskPanes.Add(ctrl, "Custom Sheet");
pane.DockPosition = Office.MsoCTPDockPosition.msoCTPDockPositionRight;
pane.DockPositionRestrict = Office.MsoCTPDockPositionRestrict.msoCTPDockPositionRestrictNoChange;
pane.Visible = true;
This is being done in the ThisAddin.cs
file and it working just fine on my machine, both under a Debug session and with the add-in installed via the click-once installer.
However, installing the add-in on a colleague's machine is proving troublesome.
The add-in is functioning and the context menu / ribbon is working perfectly, but the pane just refuses to show.
I have a toggle button on the ribbon which toggles the Visible
property on the pane and even clicking that isn't forcing the pane to show.
Any help on this would be greatly appreciated, Google is proving useless for this.
Thanks.
I should mention that CellTaskPane
is just a UserControl
as per the docs on MSDN: http://msdn.microsoft.com/en-us/library/aa942846.aspx
To make the Task Pane visible, press Ctrl+ F1 and then choose one of the Task Panes from the Task Pane dropdown list at the top right corner of the Task Pane.
On the Tools menu, click Options. The Options dialog box appears. On the View tab, under Show, click to select the Startup Task Pane check box, and then click OK. The Startup task pane appears when you restart the Office program.
By default, the Microsoft task pane opens on the right side of the Office program window. If you are running a compatible version of Microsoft Office, you can use the Ctrl + F1 keyboard shortcut to open the task pane. You may also click the View option in the program menu, and then select Task Pane.
The Task Pane is a rectangular window that appears docked on the right side of your PowerPoint window. It acts as an open menu allowing you to select from a range of commands and functions.
Turns out it wasn't anything we were doing directly!
There was another add-in installed (third party) which for some bizarre reason was interfering with the pane being shown (no idea why or how).
Shame that Excel doesn't show any sort of error or at least throw an exception.
Ah well.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With