Skip to content
REFERENCE

U.MENU

Summary

Registers Excel menu entries that will appear when the workbook is opened and be removed when it is closed

Syntax

=U.MENU(entries, [priority])

Parameters

Parameter Required Description
entries Yes The settings for the individual menu entries to be added to the Excel menu. If no settings are provided, a report of all known custom menu entries is returned
[priority] No When multiple workbooks are open that add menu entries, those with a priority set value set will be displayed before those without a priority setting; entries with a higher priority (lower priority number) are displayed first. When entries have the same priority, ordering is based on registration time

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.

Examples

=U.MENU(B3:R17,1)

=U.MENU(B19:R25)

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.