Show TOC

Function documentationEvMNU Formulas Locate this document in the navigation structure

 

The MNU commands described above can be used in Excel. The EvMNU formula allows each command to be imbedded into a cell. Clicking a cell containing an EvMNU formula launches the appropriate action. The combination of the following techniques allows you to design a menu with controlled behavior.

  • You can build a menu so that it opens a new workbook. This reduces the need to create large workbooks, which are linked through VBA “Sheets("sheet name").Select”.

  • Workbook options can further manage the expected behavior of each workbook.

  • Worksheet options can control the behavior of individual worksheets.

We recommend using a control worksheet that allows the designer to define all menu commands in a clear and consistent manner. This sheet can use other Ev functions such as EvAPP to retrieve the application ID or provide other dynamic information. This enables the same menu to be used in multiple applications.

For example, =EvMNU(“MNU_eAnalyze_OpenLibrary”,”Open Report”)

These menu commands cannot be used in a VBA macro: OPENFILE, CLOSEEXCEL, OPENWEBFOLDER, and SETCV.

Menu Command Examples

On a control sheet, the Category member can be selected by the user. When the user double-clicks the cell, the member selector for the Category-type dimension is opened to allow the user to select a different member ID. The cell contains the following formula:

=EVMNU(Controls!A26,Controls!B26)

The formula refers to the control sheet with the MNU functions.