ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Minimize the VB form (https://www.excelbanter.com/excel-programming/280921-minimize-vbulletin-form.html)

FuzzyLogic

Minimize the VB form
 
I am calling a public function of VB dll from excel macro.

This shows me a Non - Modal form, which always on Top.

Now, when excel is minimized this form remain on top.

I want to minimize this form when excel is minimized
and reset it to normal when excel is restored.

I am having the reference of the Excel in this dll, from which I am
able to catch the events of the excel in the dll.

But I could not found any event which can show me the window state of
the excel is changed.

Any Suggestions...



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/



All times are GMT +1. The time now is 10:06 PM.

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