Embeded excel's parent
 

I have a form that is created from excel process.
Is there a way to make my form act like a floating toolbar? (specifically
when the excel s embeded in another application)

Meaning that when the excel is embeded in an application for example IE if
you move the focus to another application the toolbar is not visible but when
you return to IE the toolbar is visible. Also the focus is on the excel and
not on the toolbar.

I tried to use the Application.Parent but with no success.

Embeded excel's parent
 

You have to reference Activeworkbook.

"ARHangel" wrote:

I have a form that is created from excel process.
Is there a way to make my form act like a floating toolbar? (specifically
when the excel s embeded in another application)

Meaning that when the excel is embeded in an application for example IE if
you move the focus to another application the toolbar is not visible but when
you return to IE the toolbar is visible. Also the focus is on the excel and
not on the toolbar.

I tried to use the Application.Parent but with no success.

Embeded excel's parent
 

Can you give an example?

"Joel" wrote:

You have to reference Activeworkbook.

"ARHangel" wrote:

I have a form that is created from excel process.
Is there a way to make my form act like a floating toolbar? (specifically
when the excel s embeded in another application)

Meaning that when the excel is embeded in an application for example IE if
you move the focus to another application the toolbar is not visible but when
you return to IE the toolbar is visible. Also the focus is on the excel and
not on the toolbar.

I tried to use the Application.Parent but with no success.

Embeded excel's parent
 

Set sht = ActiveWorkbook.ActiveSheet.Range("A1")
Set bar = ActiveWorkbook.Parent.Toolbars

"ARHangel" wrote:

Can you give an example?

"Joel" wrote:

You have to reference Activeworkbook.

"ARHangel" wrote:

I have a form that is created from excel process.
Is there a way to make my form act like a floating toolbar? (specifically
when the excel s embeded in another application)

Meaning that when the excel is embeded in an application for example IE if
you move the focus to another application the toolbar is not visible but when
you return to IE the toolbar is visible. Also the focus is on the excel and
not on the toolbar.

I tried to use the Application.Parent but with no success.

Embeded excel's parent
 

You did not understood my question. I want to have a form that will act like
a toolbar.

"Joel" wrote:


Set sht = ActiveWorkbook.ActiveSheet.Range("A1")
Set bar = ActiveWorkbook.Parent.Toolbars

"ARHangel" wrote:

Can you give an example?

"Joel" wrote:

You have to reference Activeworkbook.

"ARHangel" wrote:

I have a form that is created from excel process.
Is there a way to make my form act like a floating toolbar? (specifically
when the excel s embeded in another application)

Meaning that when the excel is embeded in an application for example IE if
you move the focus to another application the toolbar is not visible but when
you return to IE the toolbar is visible. Also the focus is on the excel and
not on the toolbar.

I tried to use the Application.Parent but with no success.

Embeded excel's parent
 

A userform has two modes modal and modeless. I think you want modeless.

[object.]Show modal



Settings

The settings for modal a

Constant Value Description
vbModal 1 UserForm is modal. Default.
vbModeless 0 UserForm is modeless


"ARHangel" wrote:

You did not understood my question. I want to have a form that will act like
a toolbar.

"Joel" wrote:


Set sht = ActiveWorkbook.ActiveSheet.Range("A1")
Set bar = ActiveWorkbook.Parent.Toolbars

"ARHangel" wrote:

Can you give an example?

"Joel" wrote:

You have to reference Activeworkbook.

"ARHangel" wrote:

I have a form that is created from excel process.
Is there a way to make my form act like a floating toolbar? (specifically
when the excel s embeded in another application)

Meaning that when the excel is embeded in an application for example IE if
you move the focus to another application the toolbar is not visible but when
you return to IE the toolbar is visible. Also the focus is on the excel and
not on the toolbar.

I tried to use the Application.Parent but with no success.