ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SmartDocument: RefreshPane() doesn't update TaskPane immediately (https://www.excelbanter.com/excel-programming/300716-smartdocument-refreshpane-doesnt-update-taskpane-immediately.html)

Beat Bucheli

SmartDocument: RefreshPane() doesn't update TaskPane immediately
 
Hello,

In my Excel 2003 SmartDocument (written in .Net with VSTO), I have to
show/hide several task pane controls based on the state of other task pane
controls. So I try to update the task pane:

Application.ThisWorkbook.SmartDocument.RefreshPane ();

But this does the job only partially - the task pane changes not until
another worksheet cell ist selected. What's wrong?

Thanks
Beat



Beat Bucheli

SmartDocument: RefreshPane() doesn't update TaskPane immediately
 
.... resolved, a type cast caused an exception, so RefreshPane() wasn't
executed. The 'Target' parameter in ISmartDocument.InvokeControl contains an
Excel.Workbook if the XML type name is
namespace#actionPertainsToEntireSchema. The documentation mentions only
Excel.Range...


"Beat Bucheli" schrieb im Newsbeitrag
...
Hello,

In my Excel 2003 SmartDocument (written in .Net with VSTO), I have to
show/hide several task pane controls based on the state of other task pane
controls. So I try to update the task pane:

Application.ThisWorkbook.SmartDocument.RefreshPane ();

But this does the job only partially - the task pane changes not until
another worksheet cell ist selected. What's wrong?

Thanks
Beat






All times are GMT +1. The time now is 11:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com