Excel: Adding a Separator Bar to Custom Menus

ID: Q64404


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


REFERENCES

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

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

Additional query words: 2.20 2.21 3.0 4.00

Keywords :
Version :
Platform :
Issue type :


Last Reviewed: March 21, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.