#1   Report Post  
dstiefe
 
Posts: n/a
Default 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
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I keep Toolbar Buttons on the toolbar? weberts2 Setting up and Configuration of Excel 1 July 16th 05 04:30 AM
Toolbar problem Anthony Excel Discussion (Misc queries) 1 June 1st 05 01:05 AM
how do I add sum function to the toolbar permanently speedy2 Excel Discussion (Misc queries) 1 May 21st 05 03:53 AM
"Drawing" Toolbar is inactive Deauxx Excel Discussion (Misc queries) 1 December 8th 04 03:03 PM
How do I stop the Reviewing toolbar from showing up in Excel? RickKel Excel Discussion (Misc queries) 2 November 26th 04 05:37 PM


All times are GMT +1. The time now is 03:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"