Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The following code adds an item to the cells shortcut menu.
I do want it disabled at this point. Option Explicit Private Sub Workbook_Open() Dim NewItem As CommandBarButton 'Stop Application.CommandBars("Cell").Reset Set NewItem = Application.CommandBars("Cell").Controls.Add With NewItem .Caption = "Show Detail" .OnAction = "ShowDetail" .BeginGroup = True End With Application.CommandBars("Cell").Controls("Show Detail").Enabled = False End Sub This works on my Excel 2003 system, and quite a few Excel 2000 systems, but there is one that it just won't work on. If I step thru the code, I get no errors, but it doesn't add it. I have macro security set to low. Is there something I'm missing, like something that doesn't allow my VBA code to change shortcuts?? Thanks, Alan Sawyer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What is a shortcut menu? | Excel Discussion (Misc queries) | |||
Popup Menu / Shortcut Menu | Excel Discussion (Misc queries) | |||
add to shortcut menu | Excel Programming | |||
shortcut menu | Excel Discussion (Misc queries) | |||
shortcut for menu | Excel Programming |