vbfeeds.com/Post

The content of the postings is owned by the respective author. vbfeeds.com is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on vbfeeds.com, please contact us at abuse@vbfeeds.com and we will remove it. Designated trademarks and brands are the property of their respective owners. vbfeeds.com Copyright © 2005 Serge Baranovsky. All rights reserved.

Friday, February 16, 2007

VSTO Excel solutions and disappearing Action Panes

by Maurice via Maurice de Beijer on 2/16/2007 6:55:17 PM

If you are using Actions Panes in a VSTO Excel add-in you might have seen the following behavior. You create an new ActionPane, derived from UserControl, and add it to the Workbook ActionsPane.Controls collection. It shows up nicely so you think you are done.

Now the user creates a new Spreadsheet using File/New. Note that the ActionsPane disappears and remains hidden until the user reactivates it using View/Task Pane or Ctrl+F1.

So how do you automatically display the TaskPane when the user switched back to the original document? You need to add the following code to the ThisWorkbook type:

PrivateSub ThisWorkbook_WindowActivate(ByVal Wn As Window) HandlesMe.WindowActivate

Application.DisplayDocumentActionTaskPane = True

EndSub

Enjoy!

Maurice de Beijer

www.TheProblemSolver.nl

wiki.WindowsWorkflowFoundation.eu/

Share this post: email it! | bookmark it! | digg it! | live it!

Original Post: http://msmvps.com/blogs/theproblemsolver/archive/2007/02/16/vsto-excel-solutions-and-disappearing-action-panes.aspx

© 2005 Serge Baranovsky. All rights reserved.
All feed content is property of original publisher. Designated trademarks and brands are the property of their respective owners.

This site is maintained by SubMain(), a division of vbCity.com, LLC