Microsoft KB Archive/64404

{|
 * width="100%"|

Excel: Adding a Separator Bar to Custom Menus

 * }

-

The information in this article applies to:


 * Microsoft Excel for the Macintosh, versions 2.2, 3.0, 4.0

-

SUMMARY
To add a separator line between menu commands on a Microsoft Excel custom menu, a hyphen must be placed between the two items to be separated in the menu name column of the menu definition table.

For example, to place a separator line between the first and second items on a custom menu, insert a dash (-) in row 3 of the column, thus separating the menu command in row 2 from the menu command in row 4, as follows:

  ++---+-+ | Data  |  (Menu name)                          |     | ++---+-+  |  Form  |  (Command macro reference)            |     | ++---+-+  |  -     |  (This will separate Form from Find)  |     | ++---+-+  |  Find  |  (Command macro reference)            |  E  | ++---+-+