Context menu will not invoke subroutine

[JONeill]

I have a context menu that shows when the user right-clicks on the worksheet. When I added a 10th item to it, the menu option shows up but it will not call the sub that calls the module that writes the report. Checked the syntax and created a breakpoint at the menu item being called for both the new option and a working one. The code will just not run. Here is the code.

Set myItem = myBar.Controls.Add(Type:=msoControlButton)
    With myItem
       .Caption = "Base Hours Estimate..."
       .OnAction = "HoursEstimateReport"
       .FaceId = 4
       'Indicate a new "group" by inserting a line.
       '.BeginGroup = True
    End With


'********************************************
'*          HoursEstimateReport()
'*
'* Creates the hours estimate report for the
'* current schedule.
'********************************************
Sub HoursEstimateReport()
     Dim actSheet As Worksheet
     MsgBox "HoursEstimateReport"
     
    'Set to active sheet
    Set actSheet = Application.ActiveSheet
    
    'If the current sheet is the cover sheet then
    'show error message
    If actSheet.name = FRONT_END_SHEET Then
        MsgBox "You must be on a schedule sheet to generate this report...", vbInformation, "Can't Generate Report"
    Else
        'Generate the report
        HoursEstimateReport.WriteReport
    End If
End Sub

 

[RoryA]

Does anything at all happen when you click the menu item?

 

[JONeill]

I right click and the menu comes up and the item is added but nothing will happen when I click on it.

 

[RoryA]

Do other items you have added work properly?

 

[JONeill]

Not the new one or a one I did as a test. Those two don't work. All the others do. I don't imagine there's a limit to how many items you can put on there. At least not the number of items I have.

 

[RoryA]

So you have other items that you are adding that do work? If so, try changing the order of the items so that the one that isn't working is at the start - does it work then? (Like you, I'm not aware of a limit).

Which version of Excel are you using? If it's 2010 or later, you should really use the CustomUI part of the workbook to alter the context menus.

 

[JONeill]

I'm working in 2013 but the macro will be run in 2007. I've noticed since I started doing this that sometimes a module will get corrupted. I'm wondering if I just shouldn't create a new menu module and copy the old code to it.

 

[JONeill]

I put that menu item first but the same thing is happening. On all working procedure calls, breakpoints work in the menu module but not on the 2 that I added. The proc just never gets called.

 

[RoryA]

Which module is the HoursEstimateReport in?

 

[JONeill]

I realized what it was. I had an ambiguous name but there was no runtime error that popped up. The module containing the report had the same name as the sub in the menu module. Everything seems to be working now. Thanks for taking the time to help, though.