toolbar position

  • Thread starter Thread starter M.
  • Start date Start date
M

M.

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
 
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
 
Back
Top