Microsoft KB Archive/64235

Example of Customizing Menus in Multiplan PSS ID Number: Q64235 Article last modified on 08-12-1990 PSS database name: D_MPlan

3.00 3.01 3.02 3.04 4.00 4.01 4.20

MS-DOS

Summary:

Multiplan versions 3.00, 3.01, 3.02, 3.04, 4.00, 4.01, and 4.20 were supplied with a sample worksheet called ACCREC.MOD. This is an accounts receivable worksheet designed to demonstrate the use of custom menus.

Custom menus can be designed to restrict the action of users. They can help protect data and facilitate the entry of data. The macro menu command MN prevents you from escaping the custom menus. The macro menu command MC allows you to escape the custom menu and return to the standard menu by pressing the ESC key.

For general help with macros, start Multiplan and choose Help Macro. Choose Next until the information of interest appears on the screen.

More Information:

The sample worksheet, ACCREC.MOD, contains a macro named AUTOEXEC. Immediately after the worksheet is loaded, the AUTOEXEC macro will execute and a menu will appear in place of the standard menu. To understand how this macro works, press the ESC key to return to the standard menus.

Choose Goto and then choose Name. Press a direction key to obtain a list of macros and named areas. Highlight AUTOEXEC and press the ENTER key to see the contents of the macro. The worksheet cell contains the following macro instructions:

gnIntro_Scrn’rt’goMenu_1’

This macro selects Goto and then Name. It then enters the named area “Intro_Scrn” and presses the ENTER key (’rt). The macro proceeds to use the GO macro command to begin executing instructions in the cell named “Menu_1”. “Menu_1” contains the following macro instructions:

‘mcr7c27’

The “Menu_1” macro calls the macro command MC to pull up a menu. R7C27 points to the upper left cell in a group of cells that define the menu. The first row contains the name of each menu command. The second row contains the text with instructions to be displayed on the message line. The third row begins listing the macro commands to be executed when the custom menu option is selected. If you substitute the MN menu command for MC, you can be restricted to those commands that are offered by the custom menus.

Copyright Microsoft Corporation 1990.