CUSTOM COMMAND BAR DOES NOT SHOW SOMETIMES-- WHAT COULD BE THE REASON

[CAPTGNVR]

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

 

[Bernie Deitrick]

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

 

[Gord Dibben]

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

 

[CAPTGNVR]

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

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

 

[CAPTGNVR]

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

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