CRISTAL Macro Manager: The Macro Manager allows the user to execute, name, change, erase, or debug Macro commands for each individual worksheet file. Press [Alt F10] to activate the Macro Manager. Select Manager commands from the Manager menu by pressing the first letter of the desired command, or use the Highlight Bar method. In the Manager list, use the arrow keys to position the Highlight Bar at the desired line of the Manager list where selected commands are to be implemented. Press [Enter] to record actions, or press [Esc] to return to the menu without implementing the selected command. The Macro Manager menu displays the following commands: Help: activate the Macro Manager help file. MacroX: execute the Macro specified (highlighted) in the Manager list. Add: assign a name to a Macro located at a specified cell address in the current worksheet. A maximum of 27 contiguous characters is allowed in the list for the Macro name and cell address. Example: TEST_11,AA250 Change: modify a Macro list name or address. Position the Highlight Bar at the desired name and type the necessary changes. Erase: delete a named Macro from the Manager list. The erasure of a name from the Manager list does not delete the Macro itself from the worksheet. Debug: step through a named Macro execution path in the worksheet environment. The Debug command is used to confirm the contents of the Macro chain. The Macro can be edited during the Debug procedure. Quit: exit the Macro Manager and return to the current worksheet environment. The [Esc] key can also be used to quit the Macro Manager. Macro Execution: Execution of a Macro can be initiated from the worksheet environment by pressing the [F10] Macro key. Type the desired Macro name at the Message Line query, or press [Enter] to execute the next Macro located in the worksheet (relative to the current cell location). 1. Activate the Macro Manager by pressing [Alt F10]. The Macro Manager displays a list of named Macros (if one exists for the current worksheet). Use the arrow keys to position the Highlight Bar at the named Macro that is to be executed. Press [Enter] to execute the indicated named Macro. If no named Macros are listed in the Macro Manager, press [Enter]. CRISTAL will then search forward from the current worksheet cell location for a valid Macro. The first valid Macro encountered relative to the current cell location is executed. 2. Press [/ M] to activate the Macro Command from the worksheet. Use the arrow keys to highlight the name of the Macro to be executed. Press [Enter] to execute the selected Macro. 3. Press the Macro key [F10]. At the Message Line query, type the name of the Macro to be executed, or press [Enter] to execute the next Macro located in the worksheet (relative to the current cell location). Note: For any of the execution alternatives, if no valid Macros exist in the worksheet the system beeps and displays the message: "No Macro in sheet!!! Press any key to continue" The Automatically Executable Macro: If the user assigns the name "AUTOEXEC" to a Macro, it will automatically be executed every time its worksheet file is loaded to the system. This can be effectively employed to invoke a special application procedure. There can be only one auto-execute Macro per worksheet. If the automatic execution of a Macro is no longer required, change the name or delete the Macro altogether from the MACRO applications command menu in the main menu of the worksheet. Note: A Macro can be stopped at any time by pressing the [Esc] key. Index to the Appendices Macros CRISTAL Macro Command Categories