Prev: Move data between ListBoxes
Next: PLAY RACE GAMES
From: NoSpam on 29 May 2010 17:40
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
 | 
Pages: 1
Prev: Move data between ListBoxes
Next: PLAY RACE GAMES