About Us

Jim Rech

but it will still be part of a full ribbon.

startFromScratch?

--
Jim
"Bob Phillips" wrote in message
...
| Not possible. The ribbon is not as configurable as the old commandbars.
You
| either have it all or nothing.
|
| You can create your own group using XML, but it will still be part of a
full
| ribbon.
|
| --
| HTH
|
| Bob
|
| (there's no email, no snail mail, but somewhere should be gmail in my
addy)
|
| "JasonB" wrote in message
| ...
| I am creating a menu with code that works in 03 to create a menu, and
when
| I
| call the routine, in Excel 07, the menu goes into the Add-Ins tab of the
| ribbon. If I Hide the ribbon with a different routine, the code does
not
| make this section visible. Here is a section of the code:
|
|
|

Code:

Dim myBar As CommandBar
|  'Dim SubItem As CommandBarButton
|  Dim myItem As CommandBarControl
| 
|  On Error Resume Next 'In case it has already gone.
|     Application.CommandBars("Navigation_Bar").Delete
|  On Error GoTo 0
| 
|  Set myBar = Application.CommandBars.Add(MenuBar:=True)
|     With myBar
|     .Name = "Navigation_Bar"
|     .Visible = True
|     '.Position=msoBarFloating
|     'Temporary:=True)
|     End With
|  'Add Menu Item
|  Set myItem = myBar.Controls.Add(Type:=msoControlPopup)
|  With myItem
|     .Caption = "Actions"
|     .BeginGroup = True
|  '    .FaceId = 334
|  End With
| 
|     'First Sub Item
|     Set mySubItem = myItem.Controls.Add(Type:=msoControlButton)
|     With mySubItem
|         .Caption = "Load Components"
|         .OnAction = "Load_Components"
|     End With
|     Set mySubItem = myItem.Controls.Add(Type:=msoControlButton)
|     With mySubItem
|         .Caption = "Delete Navigation Bar"
|         .OnAction = "Delete_Navigation_Bar"
|     End With

|
|
| What I would like is a clean menubar with only items in it that I
created
| like it works in 03. I would be open to another option, but hopefully
not
| the full Ribbon... It takes up too much room...
|
|

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sub-menus of main menus for Excel 2007	Eleanor Peppard	New Users to Excel	1	March 16th 10 04:12 PM
Excel 2007 menus - how can I get rid of them?	Vic Baron	New Users to Excel	4	August 21st 08 04:15 PM
EXCEL 2007 Menus	Marvin Buzz	Excel Discussion (Misc queries)	1	May 22nd 08 04:39 PM
Excel 2007 menus - XML Notepad 2007	michael.beckinsale	Excel Programming	5	February 13th 07 08:15 PM
Excel 2007 menus - is this right?	michael.beckinsale	Excel Programming	5	February 5th 07 04:09 PM