Microsoft KB Archive/20761

Multiplan: Copying Macros from One Worksheet to Another PSS ID Number: Q20761 Article last modified on 10-17-1990 PSS database name: D_MPlan

2.x 3.00 3.01 3.02 3.04 4.00 4.01 4.20

MS-DOS

Summary:

Macros can be externally copied between worksheets. The external copy command must specify the whole macro range when the copy is requested. This specification can be made by using the macro name (if it names the whole macro region) or by the cell coordinates of the macro range.

To allow the macros to be modified in the destination worksheet, the linking option should be set to “no” when the data is copied in. Macros with duplicate command key codes are externally copied without the key codes because command keys are retained from the current spreadsheet. Key codes, or command keys, for the externally copied macro will have to be redefined.

Copyright Microsoft Corporation 1990.