A New Menu Bar

In previous chapters you learned how to create useful Sub procedures. You may find that you use a particular macro so often that it would be more convenient to have it on one of Excel s drop-down menus, rather than having to run it by means of the Run command from the Macro menu. Running a command macro by means of an Excel menu command makes the custom command accessible to Excel users who are not familiar with the use of macros. 

If you have written a number of related macros, you may even decide to create a custom menu bar with several custom menus, each containing custom commands. While both Custom Menu Command and New Menu can be 

---

Once plotted, a new menu bar appears with plot options. The plot can be displayed as points, connected, or as a bar chart. The data can be presented on linear or log axes, with or without grid. Text can be placed on the display in a variety of sizes and types. Lines or arrows can be drawn or areas filled. The user can edit all axis labels and titles if desired. Re-scaling is accomplished by means of the shrink and zoom options or by entering exact scale limits. Multiple curves can be annotated with keyed symbols. Plot coordinates are displayed in real time as the operator moves the mouse over the plot. 

---