para que funcione en excel en español hay que hacer unos cambio, se los dejo con los cambios:
Code:
Sub CreaExMenu()
' origen: http://spreadsheetpage.com/index.php/tip/old_style_menus_in_excel_2007/
Dim cb As CommandBar
Dim cbc As CommandBarControl
Dim OldMenu As CommandBar
' Delete it, if it exists
On Error Resume Next
Application.CommandBars('Ex Menú').Delete
On Error GoTo 0
' Create an old-style toolbar
' Set the last argument to False for a more compact menu
Set ExMenu = Application.CommandBars.Add('Ex Menú', , True)
' Copy the controls from Excel's 'Built-in Menus' shortcut menu
With CommandBars('Built-in Menus')
.Controls('&Archivo').Copy ExMenu
.Controls('&Edición').Copy ExMenu
.Controls('&Ver').Copy ExMenu
.Controls('&Insertar').Copy ExMenu
.Controls('F&ormato').Copy ExMenu
.Controls('&Herramientas').Copy ExMenu
.Controls('&Datos').Copy ExMenu
.Controls('Ven&tana').Copy ExMenu
.Controls('?').Copy ExMenu
End With
' Make it visible. It appears in the Add-Ins tab
Application.CommandBars('Ex Menú').Visible = True
End Sub
«Antes que cambien los reinos, los hombres deberán cambiar»
═╬═