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.
Maybe I did not catch the question, but it seems that if you simply set the form's ShowModal property to False, you will get what you want.