Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toolbar position
I have a custom toolbar created when a worksheet is opened, however I want to
place it next to another toolbar everytime it is opened. I have used the following code: MyBar.RowIndex = Application.CommandBars("OtherBar").RowIndex MyBar.Left = Application.CommandBars("OtherBar").Left This would work except that at my work we have another toolbar that is created anytime excel is opened and that is the toolbar I want it next to and the code for my bar is running first so I get an error. How do I make it so my toolbar isn't created until the other toolbar has been created? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toolbar position
Perhaps you could delay your commandbar creating sub. Instead of calling it
directly in your Auto_Open or Workbook_Open sub: AddMyCmdbar you could call it like this: Application.OnTime DateAdd("s", 3, Now), "AddMyCmdbar" -- Jim "Spencer" wrote in message ... |I have a custom toolbar created when a worksheet is opened, however I want to | place it next to another toolbar everytime it is opened. I have used the | following code: | | MyBar.RowIndex = Application.CommandBars("OtherBar").RowIndex | MyBar.Left = Application.CommandBars("OtherBar").Left | | This would work except that at my work we have another toolbar that is | created anytime excel is opened and that is the toolbar I want it next to and | the code for my bar is running first so I get an error. | | How do I make it so my toolbar isn't created until the other toolbar has | been created? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom toolbar, setting docked position | Excel Programming | |||
Initial position of floating toolbar | Excel Programming | |||
Custom Toolbar Position | Excel Programming | |||
Custom Toolbar position | Excel Programming | |||
toolbar position | Excel Programming |