Menus & Hot keys - works in Excel 2003 but not 2007

[Guest]

Using 2003, I have written some code in Excel VBA that puts a menu in
Excel's main menu bar just before "Help". Works great. However in 2007,
it does not seem to appear.

The code is on the order of:
iHelpIndex = cbWSMenuBar.Controls("Help").Index
Set muCustom = cbWSMenuBar.Controls.Add(Type:=msoControlPopup,
before:=iHelpIndex)
'Create the WebData menu
With muCustom
.Caption = "&Steel"

With .Controls.Add(Type:=msoControlButton)
'Select Attribute for New/Updated Contacts
.Caption = "Create .ord && .prt files"
.OnAction = "RunJobNormal"
End With

ALSO - I assign a couple of hot keys with code like:
Application.OnKey "{f10}", "SetOptions"

In 2003, they overide the default assignments, in 2007 they do not.

How can I make my menu appear and my hot keys work in 2007.

Thanks

 

[Guest]

In case anyone may be interested - the solution was to create
program files\microsoft office\office 10
and copy refedit.dll fro the office11 folder to office10.

That solved this and a number of other problems. For example chr() and
left() were undefined. Crazy, eh?