View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
FuzzyLogic FuzzyLogic is offline
external usenet poster
 
Posts: 1
Default 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/