{"id":2206,"date":"2026-07-25T15:31:41","date_gmt":"2026-07-25T07:31:41","guid":{"rendered":"https:\/\/xlwings.net\/blog\/?p=2206"},"modified":"2026-03-28T10:43:43","modified_gmt":"2026-03-28T10:43:43","slug":"how-to-use-applicationtransitionmenukeyaction-in-the-xlwings-api-way","status":"publish","type":"post","link":"https:\/\/xlwings.net\/blog\/how-to-use-applicationtransitionmenukeyaction-in-the-xlwings-api-way\/","title":{"rendered":"How to use Application.TransitionMenuKeyAction in the xlwings API way"},"content":{"rendered":"\n

The TransitionMenuKeyAction<\/code> property of the Application<\/code> object in Excel is a legacy feature primarily designed for compatibility with older Lotus 1-2-3 spreadsheet software. Its function is to control how Excel interprets the forward slash (\/<\/code>) key press when it is the first key entered into a cell. In Lotus 1-2-3, this key combination was used to activate the menu system. Excel can mimic this behavior for users transitioning from that environment, either by displaying the Excel menu bar or by simply inserting a forward slash character into the active cell.<\/p>\n\n\n\n

Syntax in xlwings:<\/strong>
The property is accessed through the main app<\/code> object, which represents the Excel Application<\/code>. It can be both read and written.<\/p>\n\n\n\n

app.transition_menu_key_action<\/code><\/pre>\n\n\n\n
This property accepts and returns an integer value (or a constant from the xlwings.constants<\/code> enumeration) that specifies the desired action. The possible values are:<\/p>\n\n\n\n
Value<\/th>xlwings Constant<\/th>Description<\/th><\/tr><\/thead>
0<\/td>xlExcelMenus<\/code> (or None<\/code>)<\/td>The forward slash key activates the Excel menu bar.<\/td><\/tr>
1<\/td>xlLotusHelp<\/code><\/td>The forward slash key simply enters a \/<\/code> character into the cell.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
Code Examples:<\/strong><\/p>\n\n\n\n
    \n
  1. Reading the Current Setting:<\/strong>
    This example checks the current behavior of the \/<\/code> key and prints a corresponding message.<\/li>\n<\/ol>\n\n\n\n
    import xlwings as xw\nfrom xlwings.constants import xlExcelMenus, xlLotusHelp\n\napp = xw.apps.active\n\ncurrent_action = app.transition_menu_key_action\n\nif current_action == xlExcelMenus:\n    print(\"The forward slash key currently activates the Excel menu bar.\")\nelif current_action == xlLotusHelp:\n    print(\"The forward slash key currently enters '\/' into the cell.\")\nelse:\n    print(f\"Unknown setting value: {current_action}\")<\/code><\/pre>\n\n\n\n
      \n
    1. Changing the Setting:<\/strong>
      This example changes the behavior so that pressing \/<\/code> at the start of a cell entry will simply insert the character, not open menus.<\/li>\n<\/ol>\n\n\n\n
      import xlwings as xw\nfrom xlwings.constants import xlLotusHelp\n\napp = xw.apps.active\n\n# Set the property to enter the slash character\napp.transition_menu_key_action = xlLotusHelp\nprint(\"Transition menu key action set to 'xlLotusHelp'.\")<\/code><\/pre>\n\n\n\n
      <\/p>\n\n\n\n
      <\/p>\n","protected":false},"excerpt":{"rendered":"
      The `TransitionMenuKeyAction` property of the `Application` object in Excel is a legacy feature prim…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[],"class_list":["post-2206","post","type-post","status-publish","format-standard","hentry","category-xlwings-api-reference"],"_links":{"self":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/2206","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/comments?post=2206"}],"version-history":[{"count":2,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/2206\/revisions"}],"predecessor-version":[{"id":3373,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/2206\/revisions\/3373"}],"wp:attachment":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/media?parent=2206"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/categories?post=2206"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/tags?post=2206"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}