Microsoft KB Archive/24253

Custom Menus PSS ID Number: Q24253 Article last modified on 08-14-1987 PSS database name: D_MPlan

3.0 3.01 3.02

MS-DOS

Question: Can I set up a menu for macros to select only from a “custom menu,” then execute the appropriate macro?

Response: Yes. Set up a three-row by twelve-column area containing the menu portion of your spreadsheet. The first row of this area will contain the command labels for the menu. The second row will contain the descriptions of what the commands will accomplish. The third row will contain the macros that perform the desired tasks. This area is invoked from a macro that contains the line “mcname”, the name portion immediately following being the name of the area containing the menu. As an example, give the menu area the name “menu”. Invoke it by running another macro with the line “mcmenu”. When running the macro that calls the custom menu, the regular command line is replaced by the one created by typing the command labels in the first row of the menu matrix. By tabbing or spacing to the command we want to execute and pressing ENTER, the macro in the third row of the same column in the menu area is executed. This procedure also is described in the manual on Page 229.

Copyright Microsoft Corporation 1987.