Hi,

We have a spreadsheet that is used by many people across many locations. As this sheet has grown we have needed to free up some space. And so I have desgined a custom menu that all users will have installed in Excel that will run macros that relate to the spreadsheet.

The macro's stored in the spreadsheet are quite lengthy, so I didn't want to copy the code into the custome menu. I wanted to call them from the menu like so:

Sub SaveDetails()

If ActiveWorkbook.Name <> "Template.xls" Then
        MsgBox "Please Open Template", vbInformation, "CRM Menu"
    Else
        
        Call Application.Run("Template.xls!SaveExposure")
        Call Application.Run("Template.xls!SaveSummary")
        Call Application.Run("Template.xls!SaveReview")

End If

End Sub
However I'm getting an error to say that it cannot find the Macro, could somebody tell me what I'm doing wrong?

Many Thanks

Macro1