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. |
All times are GMT +1. The time now is 02:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com