Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom command | Excel Discussion (Misc queries) | |||
Custom Command Bars | Excel Discussion (Misc queries) | |||
Custom footer settup changes for unknown reason. | Excel Discussion (Misc queries) | |||
Alt command for custom menu | Excel Programming | |||
custom command bar | Excel Programming |