Menu command

Some SpartanView procedures are identical to SpartanBuild procedures and are not described m detail In particular the same mouse button keyboard combinations are used to rotate translate and scale models Also the same menu commands are used to change the model display and obtain geometry data Please refer back to the SpartanBuild instructions for help with these operations... 

At Its completion, the startup command procedure invokes the Master Menu command procedure. The Master Menu is simply a gateway to the subsidiary menus. 

After choosing Setup menu options, execute chemical calculations from Compute menu commands to perform one of the followings. 

SpartanBuild adopt many of the same procedures used by SpartanView. For example, cominands for chan ng the model display are located On the Modrtl menu, commands for measuring geometry are located mi the Oeom-elry menu, and models are moved and scaled using the same combination of mouse and keyboard commands Ufied in SpartanView... 

You can also choose Move or Copy Sheet... from the Edit menu to move a worksheet. In addition to moving sheets within the active workbook, this menu command allows you to move one or more worksheets to another workbook. 

A menu command with an ellipsis (...), such as Save As..., indicates that the command opens a dialog box to obtain user input. 

Some menu commands are dimmed (i.e., appear as gray characters) when the menu command is imavailable. Others appear on the menu only when they are available. 

Some menu commands change the text of their command depending on circumstances. For example, if you use Comment to add a comment to a cell, the command changes to Edit Comment so that you can edit the text of the comment. 

Some menu commands are preceded by a check mark if the choice has been selected previously. To remove the selection, depending on the command you either click on the check mark or select the command again. 

Many menu commands can be carried out by using toolbuttons. Toolbuttons are more convenient they often combine a whole series of actions — menu selection plus dialog box options — into a single click of the mouse button. 

Most menu commands for managing documents are in the File menu. For the most part, the menu is similar to the File menu in other Windows or Macintosh applications, with New..., Open..., Close, Save, Save As..., Page Setup..., Print Preview..., Print... and Exit (Windows) or Quit (Macintosh) commands. The Save Workspace... command is specific to Excel. 

Menu commands for printing documents are located in the File menu. USING PAGE SETUP... 

Excel Tip. You can use the Paste Values ( toolbutton instead of the Paste Special... menu command. See Chapter 19 for instructions on how to make this button, and many others, available. 

Once the desired chart element has been selected, choose Format from the Chart Menu Bar. In Excel 2000 there is a single context-sensitive menu command in the Format menu, which appears as Selected Axis..., Selected Data Series..., etc., depending on which chart element is selected. 

EXAMPLE. When text and a number value are concatenated, the number can no longer be formatted by using menu commands or tool buttons. For example, if cell A1 contains today s date (e.g., July 1 2001), then the formula... 

Excel provides a number of menu commands and functions that permit you to use a list as a database. You can use menu commands to find records in the database that match criteria that you define, or you can use worksheet fimctions to extract numerical information from a database. 

The transpose is obtained by using the worksheet function TRANS POSE (array) or the Transpose option in the Paste Special... menu command (see "Using Paste Special to Transpose Rows and Columns" in Chapter ) ... 

The SolvStat.xls macro is an Auto Open macro when you Open the document it will appear on screen and then Hide itself. It installs a new menu command. Solver Statistics..., directly under the Solver... command in the Tools menu. If the Solver Add-In has not been loaded, the Solver Statistics... command will be at the top of the menu. The command will remain in the menu imtil you exit from Excel. 

Here are some (but not all) of the ways to run a command macro from the Macro dialog box, as described in this chapter by means of a shortcut key, as described in this chapter by means of a custom menu command, as described in Chapter 18 by means of a custom button on a toolbar, as described in Chapter 19 by means of a button on a worksheet, as described in Chapter 8 as a subroutine called by another macro, as described in Chapter 15... 

VBA Help lists 267 methods. Many of them correspond to familiar menu commands. For example. Copy, Cut, Clear and Sort can be performed on a range of cells. Some useful VBA methods are listed in Table 14-2. 

If you use a worksheet function within VBA that returns an array, the lower array index will be 1. Such worksheet functions include LI NEST, TRANSPOSE, MINVERSE, MMULT. Other functions that return arrays include the VBA function Caller when used with a menu command or toolbutton. 

A command macro (a Sub procedure) can automate any sequence of actions that can be performed by the use of menu commands or keystrokes. Many simple but useful command macros can be created entirely by using the Recorder, as described in Chapter 13. But command macros can also carry out much more complicated actions. In this chapter we ll look at some examples of creating more advanced Sub procedures. 

In earlier versions of Microsoft Excel, menu bars contained only menus, and toolbars only toolbuttons. Beginning with Excel 97, toolbuttons and menu items are both members of the class of CommandBarButton objects. Command bars can contain buttons or menus or both. In general, however, mixing buttons and menu commands on the same toolbar doesn t seem to be a good idea, so this chapter deals exclusively with menus and Chapter 19 with toolbars. 

You can modify existing menus or menu bars by using the Customize command in the Tools menu. Each version of Excel has used a different method to customize menus Excel 5/95 used the Menu Editor to modify menus. Excel 97 displayed a customizable copy of the menu bar in which to make changes, but in Excel 2000 menus are customized in exactly the same way as toolbars — by dragging the menu command to the desired place on the menu bar. 

You can add any of Excel s built-in menu commands to a menu, or remove menu commands that you don t use. The procedures in the following boxes cover these possibilities. 

Some commands in the list of commands in the Commands tab have an icon beside them, others don t. Commands with an icon are toolbuttons, and those without an icon are menu commands. 

Drag the menu command off the menu (when you click on it, the menu command is highlighted) and release the mouse button. The menu command will disappear. You can remove a complete menu from a menu bar in the same way. 

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

Excel Tip If you add a built-in menu to a toolbar and make changes to the menu, the changes will also appear in the built-in menu on the menu bar. Thus if you want a modified File menu on a custom menu bar, you should add a custom menu, rename it File, and then add the desired menu commands. 

To add a custom menu command to a menu, use the procedure in the following box. 

To Add a Custom Menu Command to a Menu Bar and Assign a Macro to It... 

In the shortcut menu, type the text for the new menu command in the Name input box (the default text is " Custom Menu Command"). 

To insert a separator bar above the new menu command, choose Begin a Group from the shortcut menu to remove a separator bar, uncheck Begin a Group from the shortcut menu. 

If you create a macro to be used by other people, you can make it easy for them to use the macro by installing a custom menu command. As well, you can install the new menu command by means of an automatic procedure, so that all the users have to do is open the macro document. There are two ways you create an automatic procedure by creating an Auto Open macro in a module sheet, or by creating a Workbook Open event procedure. These are described in the sections that follow. 

In contrast to changes to menus made by using the Customize... command, menus and menu commands installed by using VBA are not saved when you quit Microsoft Excel. 

ADDING A MENU COMMAND BY MEANS OF AN AUTO OPEN MACRO... 

To install a new menu command whenever Excel is started, create an Auto Open procedure in the Personal Macro Workbook. To install a new menu command when a particular workbook is opened, create an Auto Open procedure in that workbook. Use the MenuBars and Menus VBA keywords to specify where the new Menultem is to be added, with the Add keyword. The syntax of the Add method is ... 

Figure 18-2 illustrates an Auto Open procedure that installs a new menu command in the Tools menu and assigns the Sub procedure named CommandHandler to it. To install your own custom menu command in a menu, replace Tools, New Menu Item and CommandHandler with the name of the menu, the text of your menu command and the name of your macro. 

---