ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Toolbar (https://www.excelbanter.com/excel-discussion-misc-queries/38581-toolbar.html)

dstiefe

Toolbar
 
I've created a toolbar...how do I get the toolbar to automatically "dock"
under the "main" menu (i.e. File ..Edit...View....etc..)

Thank you

Dave Peterson

Maybe something like:

Option Explicit
Sub testme()

Dim myTB As CommandBar

On Error Resume Next
Application.CommandBars("hithere").Delete
On Error GoTo 0

Set myTB = Application.CommandBars.Add(Name:="hithere", _
Position:=msoBarTop, temporary:=True)

myTB.Visible = True
With Application.CommandBars("standard")
myTB.RowIndex = .RowIndex
myTB.Left = .Width 'or 0???
End With

End Sub

dstiefe wrote:

I've created a toolbar...how do I get the toolbar to automatically "dock"
under the "main" menu (i.e. File ..Edit...View....etc..)

Thank you


--

Dave Peterson


All times are GMT +1. The time now is 05:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com