Hello Ron,
Thank you for responding. This is the VBA code that I have been using:
'Hide standard short cut menu
For Each icbc In Application.CommandBars("cell").Controls
icbc.Visible = False
Next icbc
'Add new buttons, added navigation and filter button as part of V0.5,
4March2008
With Application.CommandBars("cell").Controls _
.Add(Type:=msoControlButton, before:=1, temporary:=True)
.Caption = "Edit Object"
.OnAction = "MyFirstMacro"
End With
This works fine in 2003 and most 2007 machines. It does not work on one
machine with 2007. In the case when the it does not work, the default Excel
short cut menu comes up. A copy of the file works fine on my machine,
running Excel 2007. Is there something with the most recent version of Excel
2007? Are there some settings that would cause this? Is it the computer
configuration? Is it the operating system? I have no clue. Any thoughts or
guidance would be greatly appreciated.
:
If you change the Cell menu with VBA it wil work in 2003 and in 2007
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
Hello Joel,
Thank you for your answer. I am pretty sure that I did not explain the
problem well. I am having issues with the short cut menus that pop up when
you right click over a cell. On my computer running Excel 2007, the custom
menus works fine. On at least one other computer, right clicking brings up
the stand short cut menu. The only clue that I have is that this computer
just had Excel 2007 loaded onto it.
So far, it has only been on one computer that there is an issue. Excel 2003
continues to work well. Again, any help you could provide would be greatly
appreciated.
:
the top level menu names are different in 2003 and 2007. If you code
say to instal a menu after Windows (menu option in 2003) there wil not
be a menu called Window in 2007 and the code will not work without
changing the location to install the menu. One solution would be to get
a count of the number of menu items and then install the new menu after
the last menu.
--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:
http://www.thecodecage.com/forumz/showthread.php?t=161892
Microsoft Office Help
.
.