Lotus 1-2-3 and Quattro Pro macros appear on the worksheet as a series of commands in a column. For example, the following macro commands
{Goto}A1~
{?}
{R}
{Cell-Enter "=A1*1.1"}
{CALC}
do the following:
- Select cell A1.
- Pause for you to enter a number.
- Select the cell to the right.
- Enter the formula =A1*1.1.
- Calculate the worksheet.
Earlier versions of Microsoft Excel run this type of macro when you assign a single keystroke to the macro, such as CTRL+W or CTRL+A. However, Microsoft Excel 2000 does not run Lotus 1-2-3 or Quattro Pro macros. You can automate these commands using Microsoft Visual Basic for Applications macro commands.
For additional information about macro compatibility with Lotus 1-2-3 macros, click the article number below
to view the article in the Microsoft Knowledge Base:
258427�
XL2000: Macro Compatibility with Microsoft Excel