| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embeded IF Statement | Excel Worksheet Functions | |||
| More than 7 embeded if statements | Excel Worksheet Functions | |||
| Parent of the embeded excel | Excel Discussion (Misc queries) | |||
| Embeded Wav | Excel Programming | |||
| worksheet embeded ? | Excel Programming | |||
Linear Mode
