Prev: Why would the VB6 exe not show up in the task bar
Next: ReDim Array Causing Page Faults
From: avi on 9 Apr 2010 05:20
It's definitely a VB6 form activated from a compiled DLL. Double
clicking on some objects in Excel sheets triggers the VB6 form through
a form_load procedure . It is not VBA!

Excel and the current sheet are referenced in the VB6 program

The form is minimizing itself (not hiding) and could be maximized
again

Regards
Avi
From: Helmut Meukel on 9 Apr 2010 07:07
"avi" <aviben(a)bezeqint.net.il> schrieb im Newsbeitrag
news:1407f5a9-b69d-4845-b173-d0f004541889(a)r1g2000yqj.googlegroups.com...
> It's definitely a VB6 form activated from a compiled DLL. Double
> clicking on some objects in Excel sheets triggers the VB6 form through
> a form_load procedure . It is not VBA!
>
> Excel and the current sheet are referenced in the VB6 program
>
> The form is minimizing itself (not hiding) and could be maximized
> again
>
> Regards
> Avi



Avi,

who really calls the DLL?
There must be some macro code / VBA code calling methods
and/or setting properties of the DLL.
Is there any code in the LostFocus event of the form which
minimizes the form?
Maybe even some VBA code which sets a property of
the DLL changing the WindowsState of the form.

As I said in my last post, "some code may probably help".

Helmut.

From: Paul Clement on 9 Apr 2010 08:46
On Thu, 8 Apr 2010 12:43:38 -0700 (PDT), avi <aviben(a)bezeqint.net.il> wrote:

� Hello,
� I'm using a Vb6 form in an Excel application. The problem is that the
� VB6 compiled form minimizes automatically when selecting a cell in
� the
� active sheet
� Is there a possibility to maintain the form visible on the screen
� Thanks
�
� I've submitted the question to Excel prog group, but no answer so far
�
� Avi

Is the Form displayed as modal from the ActiveX DLL?


Paul
~~~~
Microsoft MVP (Visual Basic)
From: RB Smissaert on 9 Apr 2010 13:18
What might help is setting Excel (the Excel application window) as the
parent window
with the SetWindowLong API. Another option might be to make a VBA form (if
you use that)
the parent window.

RBS


"avi" <aviben(a)bezeqint.net.il> wrote in message
news:9655b6ce-d94e-4fd4-998e-712bb850acb8(a)u22g2000yqf.googlegroups.com...
> Hello,
> I'm using a Vb6 form in an Excel application. The problem is that the
> VB6 compiled form minimizes automatically when selecting a cell in
> the
> active sheet
> Is there a possibility to maintain the form visible on the screen
> Thanks
>
> I've submitted the question to Excel prog group, but no answer so far
>
> Avi

First  |  Prev  | 
Pages: 1 2
Prev: Why would the VB6 exe not show up in the task bar
Next: ReDim Array Causing Page Faults