How control where the CommandBar will be placed?

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

By trial and error (don't know if it will work exactly the same on all
systems):

With CommandBars("MyCommandBar")
.Top = 50
.Left = 0
End With

--

Vasant


"Gunnar Johansson" <Gujo_454@hotmail.com> wrote in message
news:OL7jHk$UFHA.1508@tk2msftngp13.phx.gbl...
> 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
>
>

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" <Gujo_454@hotmail.com> wrote in message news:OL7jHk$UFHA.1508@tk2msftngp13.phx.gbl...
> 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

Hi,

Still I want the commandbar to be located together with the ordinary ones. I
wasn't clear on this. I guess your code will make it a floationg bar, right
or wrong?

Kind Regards


"Vasant Nanavati" <vasantn *AT* aol *DOT* com> skrev i meddelandet
news:ODboq5$UFHA.3544@TK2MSFTNGP12.phx.gbl...
> By trial and error (don't know if it will work exactly the same on all
> systems):
>
> With CommandBars("MyCommandBar")
> .Top = 50
> .Left = 0
> End With
>
> --
>
> Vasant
>
>
> "Gunnar Johansson" <Gujo_454@hotmail.com> wrote in message
> news:OL7jHk$UFHA.1508@tk2msftngp13.phx.gbl...
>> 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
>>
>>
>
>

Yes. Jim's suggestion is a lot better.

--

Vasant

"Gunnar Johansson" <GuJo_454@hotmail.com> wrote in message
news:uGCmgFBVFHA.1604@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> Still I want the commandbar to be located together with the ordinary ones.
I
> wasn't clear on this. I guess your code will make it a floationg bar,
right
> or wrong?
>
> Kind Regards
>
>
> "Vasant Nanavati" <vasantn *AT* aol *DOT* com> skrev i meddelandet
> news:ODboq5$UFHA.3544@TK2MSFTNGP12.phx.gbl...
> > By trial and error (don't know if it will work exactly the same on all
> > systems):
> >
> > With CommandBars("MyCommandBar")
> > .Top = 50
> > .Left = 0
> > End With
> >
> > --
> >
> > Vasant
> >
> >
> > "Gunnar Johansson" <Gujo_454@hotmail.com> wrote in message
> > news:OL7jHk$UFHA.1508@tk2msftngp13.phx.gbl...
> >> 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
> >>
> >>
> >
> >
>
>