View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default How control where the CommandBar will be placed?

Gunnar,

This places a new command bar to the left of the Formatting toolbar.
If you want the next row up, change "Formatting" to "Standard".
'----------------------------
Dim MyCommandBar As Office.CommandBar
Set MyCommandBar = CommandBars.Add(Name:="MyBar", _
Position:=msoBarTop, Temporary:=True)
'Add some buttons here
MyCommandBar.RowIndex = _
Application.CommandBars("Formatting").RowIndex
MyCommandBar.Visible = True
Set MyCommandBar = Nothing
'--------------------------

Jim Cone
San Francisco, USA


"Gunnar Johansson" wrote in message ...
Hi,
I have a CommandBar with buttons that always is placed below the ordinary
menues/bars. If I relocate it to a better place, it always come back below
again. Can I control where it should be located? On second commandbar row to
the left?
Kind Regards