ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Custom Toolbar Docked amidst all other toolbars (https://www.excelbanter.com/excel-programming/379201-re-custom-toolbar-docked-amidst-all-other-toolbars.html)

Jim Cone

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