XL2000: Some Macros Don't Run After You Upgrade to Excel 2000 (258777)

SYMPTOMS

After you upgrade from an earlier version of Microsoft Excel to Excel 2000, your macro does not run when you press the shortcut keys assigned to run it.

For example, when you press CTRL+Z to run your macro, it does not run.

WORKAROUND

You can rewrite any of your Lotus 1-2-3 or Quattro Pro for DOS macros in Microsoft Visual Basic for Applications.

For additional information about rewriting your Lotus 1-2-3 macros in Visual Basic for Applications, click the article number below to view the article in the Microsoft Knowledge Base:

148240 XL: Visual Basic Equivalents for Lotus Macro Commands (WE1277)

MORE INFORMATION

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

REFERENCES