View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Custom Toolbar Docked amidst all other toolbars


Use the Position property...
.Position = msoBarTop

And the RowIndex property...
.RowIndex = Application.CommandBars("Formatting").RowIndex

Also, you may have to set the .Left property...
.Left = Application.CommandBars("Formatting").Width
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware




"Spencer Hutton" wrote in message
...
I have an add-in that when the Workbook_Open event occurs, the toolbar is
added to the commandbars collection. conversely it is deleted on exit with a
similar subroutine. when the toolbar loads, it positions itself just below
the bottom most toolbar in the active window. i always have to grab it and
move it up. it is docked, but it just keep placing itself on the next
toolbar row. how can i make it position itself within all of the other
toolbars each time in the same place. there is room for it to fit.