EvMNU Functions and VBA Macros with MNU Commands 
You can use EvMNU functions and VBA macros to define a workbook that can contain a list of reports, input schedules, or tasks pertaining to your specific business processes. You build these workbooks in the interface for Excel using the EvMNU function, which leverages the standard Planning and Consolidation MNU commands. You can create one or more menus for end users, or you can add their functionality to any report or input schedule.
The use of EvMNU functions vs. MNU macros in VBA is a design decision. VBA macros provide the ability to combine a series of tasks and present the user with a single button for selection. While an evMNU function is a click action in a worksheet cell, it may be less user friendly, but just as effective.
The design of the commands allows experienced VBA users to write custom macros that combine both standard Planning and Consolidation and Microsoft Excel tasks.
Example
Here is an example of when you would use a custom menu:
You create a series of options that allow a user to understand the required tasks for a business process. For example, the worksheet contains a list of tasks that help the user understand what they need to complete for the month end close. The list includes links to input schedules, data manager packages, work status settings, and other related tasks to complete the financial close. For example, see Scenario 2 – Menu Creation Using EvMNU Formulas.
Example
Here is an example of when you would use a VBA (MNU) macro:
You want the user to perform a specific task from a report, so you use a VBA macro to expand the workbook, then park the workbook to take it offline. For more information, see Creating Buttons for VBA (MNU) Macros.