Hello,

When I point to another application in the Windows taskbar programs
(just right clicking any application name), the current selection in
the active sheet appears desselected, although I suspect that the
selection is still valid from a programatical point of view

Is there a way to override this strange behavior?



Thanks a lot
Avi

Define what you mean by:

Is there a way to override this strange behavior?

The behavior you described is by design.


"avi" wrote:

Hello,

When I point to another application in the Windows taskbar programs
(just right clicking any application name), the current selection in
the active sheet appears desselected, although I suspect that the
selection is still valid from a programatical point of view

Is there a way to override this strange behavior?



Thanks a lot
Avi

I mean:

Could the range still appear selected?

I explain my problem:

I have created an Excel add-in written in VB6 and compiled to a dll

When the user invokes the add-in, a form is displayed that refers to
the active selection. But when the form appears, the range appears
desselected

I look for a way to keep the range appearing selected

Thanks
Avi

I have not worked with add-ins, so I do not know what their characteristics
are in relation to focus, modality, etc. Maybe someone more knowledgeable
will respond.


"avi" wrote in message
...
I mean:

Could the range still appear selected?

I explain my problem:

I have created an Excel add-in written in VB6 and compiled to a dll

When the user invokes the add-in, a form is displayed that refers to
the active selection. But when the form appears, the range appears
desselected

I look for a way to keep the range appearing selected

Thanks
Avi