Excel: Adding a Separator Bar to Custom Menus

• 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  |
   +--------+---------------------------------------+-----+

REFERENCES

"Microsoft Excel User's Guide" version 3.0, page 638

"Microsoft Excel Functions and Macros" version 2.2, pages 153-163