[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question
[x]
Attachment Details

Accessing the ViewDocumentActionsPane button in Excel 2007

Asked by KasperTheFriendly in Microsoft Excel Spreadsheet Software, Office & Productivity Software, Microsoft Visual C#.Net

Tags: VSTO, microsoft office 2007, ToggleButton

So - here is the situation.

In a vsto document level solution, I am attempting to create a dialog inside the Actions Pane of the workbook which will protect the user from closing the action pane until the dialog has been completed.

I have looked through several forums, and have found that this is impossible, mainly because the  "VisibleChanged" event of the action pane does not fire when a user closes the pane.

So, as a workaround, I would like to access the Control Name "ViewDocumentActionsPane" inside the "GroupZoom" group in the "TabView" tab of the default excel 2007 ribbon. The "ViewDocumentActionsPane" control is a toggle button which is created upon the first instantiation of the ActionPane. At least with access to this control, I will be able to find out when the action pane was closed, so that I may re-open and warn the user.

I have yet to figure out a way to access this control. Has anyone run into a similar problem (or hopefully a solution)?

Thank you,
KasperTheFriendly
 
Loading Advertisement...
20091111-EE-VQP-89 - Hierarchy / EE_QW_3_20080625