DEAR ALL
I have put custom command bar by name 'GNVR_BRIDGE' and have put a vb
to make it visible on opening the workbook.
Application.CommandBars("GNVR_BRIDGE").Visible = True.

Very frequently I have to right click and unselect and again select it
for it to appear.

I drag the the only toolbar menu (standard) which is there out then i
can see my command bar.

How to set this right. yes I delete this custom command bar on
closing the workbook

Try setting the rowindex property or the position property, or both:

With Application.CommandBars("GNVR_BRIDGE")
.Visible = True
.Position = msoBarTop
.RowIndex = Application.CommandBars("Standard").RowIndex + 1
End With

HTH,
Bernie
MS Excel MVP


"CAPTGNVR" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> DEAR ALL
> I have put custom command bar by name 'GNVR_BRIDGE' and have put a vb
> to make it visible on opening the workbook.
> Application.CommandBars("GNVR_BRIDGE").Visible = True.
>
> Very frequently I have to right click and unselect and again select it
> for it to appear.
>
> I drag the the only toolbar menu (standard) which is there out then i
> can see my command bar.
>
> How to set this right. yes I delete this custom command bar on
> closing the workbook
>

You can designate where the toolbar is to appear.

See the code for this at Debra Dalgleish's site.

http://www.contextures.on.ca/xlToolbar02.html



Gord Dibben MS Excel MVP




On 16 Feb 2007 09:03:49 -0800, "CAPTGNVR" <(E-Mail Removed)> wrote:

>DEAR ALL
>I have put custom command bar by name 'GNVR_BRIDGE' and have put a vb
>to make it visible on opening the workbook.
>Application.CommandBars("GNVR_BRIDGE").Visible = True.
>
>Very frequently I have to right click and unselect and again select it
>for it to appear.
>
>I drag the the only toolbar menu (standard) which is there out then i
>can see my command bar.
>
>How to set this right. yes I delete this custom command bar on
>closing the workbook

On Feb 17, 2:37 am, "Bernie Deitrick" <deitbe @ consumer dot org>
wrote:
> Try setting the rowindex property or the position property, or both:
>
> With Application.CommandBars("GNVR_BRIDGE")
> .Visible = True
> .Position = msoBarTop
> .RowIndex = Application.CommandBars("Standard").RowIndex + 1
> End With
>
> HTH,
> Bernie
> MS Excel MVP
>
> "CAPTGNVR" <captg...@gmail.com> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
>
>
> > DEAR ALL
> > I have put custom command bar by name 'GNVR_BRIDGE' and have put a vb
> > to make it visible on opening the workbook.
> > Application.CommandBars("GNVR_BRIDGE").Visible = True.
>
> > Very frequently I have to right click and unselect and again select it
> > for it to appear.
>
> > I drag the the only toolbar menu (standard) which is there out then i
> > can see my command bar.
>
> > How to set this right. yes I delete this custom command bar on
> > closing the workbook

THNK U BERNIE- I got the lead and tried various options and got the
hang of it.

On Feb 17, 3:03 am, Gord Dibben <gorddibbATshawDOTca> wrote:
> You can designate where the toolbar is to appear.
>
> See the code for this at Debra Dalgleish's site.
>
> http://www.contextures.on.ca/xlToolbar02.html
>
> Gord Dibben MS Excel MVP
>
> On 16 Feb 2007 09:03:49 -0800, "CAPTGNVR" <captg...@gmail.com> wrote:
>
> >DEAR ALL
> >I have put custom command bar by name 'GNVR_BRIDGE' and have put a vb
> >to make it visible on opening the workbook.
> >Application.CommandBars("GNVR_BRIDGE").Visible = True.
>
> >Very frequently I have to right click and unselect and again select it
> >for it to appear.
>
> >I drag the the only toolbar menu (standard) which is there out then i
> >can see my command bar.
>
> >How to set this right. yes I delete this custom command bar on
> >closing the workbook

THNK YOU GORD, yes found the site useful and getting more knowldg.