can't find macro custom right click menu

[Martin_King]

Hi,

Creating custom right click menu options, but having issues finding the macro that I'm trying to call.

The following is added to VBA personal.xls ThisWorkbook:

 
Option Explicit
Private Sub Workbook_Open()
application.CommandBars("Cell").Reset
With application.CommandBars("cell").Controls
    With .Add
         .Caption = "&Retrieve"
         .OnAction = "!RetrieveEssbase"
         .Tag = "Retrieve essbase for selection"
         .BeginGroup = True
    End With
    
    With .Add
         .Caption = "Paste &Values"
         .OnAction = "!PasteonlyValues"
         .Tag = "Paste Special Values"
    End With
End With
End Sub

I then have the following in Cell_Menu module:

 
 
Sub PasteonlyValues()
selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
End Sub

The macros are added to the right click menu, and the Essbaseretrieve works fine, but when I click the paste special values option, it says it can't find the macro

any ideas why this wouldn't be working?

Thanks,
Martin

[Andrew Poulsom]

If RetrieveEssbase is working why don't you put PasteonlyValues in the same module?

[RoryA]

or change the OnAction to

.OnAction = "Cell_Menu.PasteonlyValues"

[Martin_King]

Thanks Rorya, adding the cell_menu. seemed to do the trick

Strange, I already had the paste special code in the same module as the essbase retrieve, however I don't have to add the cell_menu to the later. Not sure why but it is working now so thanks alot