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

  • Thread starter Thread starter CAPTGNVR
  • Start date Start date
C

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
 
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
 
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
Click to expand...

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