Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
toolbar position
Excel97!
Whene i'm opening my workbook, vba code created on the fly my toolbar. Excel positioned my toolbar below other excel toolbar. Could i write some code to position my toolbar to the right of other defolt excel toolbar. My toolbar contained only two toolbar buttons, there for is enought smoll to bi positioned to the right of other excel toolbar. Regards, Milos |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
toolbar position
Try this, not sure if it work
Sub BarPosition() Dim BarLeft As Long BarLeft = Application.CommandBars("Standard").Width + 1 With Application.CommandBars("Your toolbar name") .Position = msoBarTop .Left = BarLeft .Visible = True End With End Sub "M." wrote in message ... Excel97! Whene i'm opening my workbook, vba code created on the fly my toolbar. Excel positioned my toolbar below other excel toolbar. Could i write some code to position my toolbar to the right of other defolt excel toolbar. My toolbar contained only two toolbar buttons, there for is enought smoll to bi positioned to the right of other excel toolbar. Regards, Milos |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel toolbar like word toolbar, please | Excel Discussion (Misc queries) | |||
Form Toolbar verses Control Toolbar | Excel Discussion (Misc queries) | |||
Save Toolbar into new toolbar | Excel Discussion (Misc queries) | |||
Adjusting toolbar size, restore toolbar | Excel Discussion (Misc queries) | |||
saving toolbar buttons on custom toolbar | Excel Programming |