Microsoft KB Archive/258777

= XL2000: Some Macros Don't Run After You Upgrade to Excel 2000 =

Article ID: 258777

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q258777



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.



CAUSE
This problem occurs when your workbook contains macros written in either Lotus 1-2-3 or Quattro Pro for DOS macro commands. Microsoft Excel 2000 does not run these macro commands.



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 &quot;=A1*1.1&quot;} {CALC} do the following:
 * 1) Select cell A1.
 * 2) Pause for you to enter a number.
 * 3) Select the cell to the right.
 * 4) Enter the formula =A1*1.1.
 * 5) 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

