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

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