Embeded excel's parent

[ARHangel]

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.

 

[Joel]

You have to reference Activeworkbook.

 

[ARHangel]

Can you give an example?

You have to reference Activeworkbook.

 

[Joel]

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

 

[ARHangel]

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

 

[Joel]

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

[object.]Show modal



Settings

The settings for modal are:

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