需要在excel主窗口（准任务窗格）上放置一个浮动的无模式窗体 [英] Need to place a floating modeless form over excel main window (quasi-task pane)

问题描述

我需要通过在Excel主窗口中浮动无模式窗体来模拟任务窗格。这个要求的原因是我需要为我的Excel 2003 加载项提供taskpane功能，但不能使用以文档为中心的模型。

任何人都可以建议什么是最好的方法呢？无模式窗体将需要检测主窗口resize事件并相应地调整其大小，并且还需要始终将其自身置于窗口的底部（类似于对接窗格）。

解决方案

我将分享我迄今为止发现的内容。 Code Project中的一篇文章非常翔实，我认为这将有助于我弄清长远来说我需要做的事情，尽管它涉及到Outlook面板集成。我没有时间真正尝试将下面列出的解决方案整合到我的Excel项目中，但文章中概述的想法看起来很坚定。

http://www.codeproject.com/KB/office/additional_panel_Outlook.aspx

一旦获得更多信息，我会更新我的帖子。

Hi I need to emulate a task pane by floating a modeless form over the Excel main window. The reason for this requirement is that I need to have taskpane features for my Excel 2003 add-in, but cannot use the document-centric model.

Can anyone suggest what would be the best way to do this? The modeless form would need to detect the main window resize event and resize itself accordingly, and also need to always position itself at the bottom of the window (kind of like a docking pane).

解决方案

I'm going to share what I've found so far. One article in Code Project was very informative, I think this will help me figure out what I need to do over the long run, although it's about Outlook panels integration. I haven't had time to really try and integrate the solution outlined below into my Excel project, but the idea outlined in the article seems solid.

http://www.codeproject.com/KB/office/additional_panel_Outlook.aspx

I'll update my post once I get more information.

这篇关于需要在excel主窗口（准任务窗格）上放置一个浮动的无模式窗体的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！