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

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

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

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" wrote in message
oups.com...
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

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

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" 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

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

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" wrote in message

oups.com...





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.

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

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" 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.