Microsoft KB Archive/214288

= XL2000: AutoSave Command Recorded in Subroutine or Macro =

Article ID: 214288

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214288





SYMPTOMS
In Microsoft Excel 2000, if you record a Visual Basic for Applications macro while the AutoSave add-in is functioning, and the AutoSave add-in prompts you to save a file while you are recording, the following line of code is recorded in your subroutine. Application.Run Range("AUTOSAVE.XLA!mcs02.OnTime")



CAUSE
This problem occurs because the macro recording system in Microsoft Excel is aware of macros that are assigned to run at a certain time (for instance OnTime macros). If such a macro runs while the macro recorder is operating, the command to run that macro is recorded.



WORKAROUND
To work around this behavior, use either of the following methods:  After you have finished recording your macro, remove or comment out any commands that should not be contained in the macro.

-or- Before starting to record a new subroutine or macro, turn off any OnTime macros that are present.

For example, to turn off AutoSave in Microsoft Excel 2000, follow these steps:  On the Tools menu, click AutoSave.

If AutoSave is not displayed on the Tools menu, the AutoSave add-in is not installed. To install this add-in, follow these steps:  On the Tools menu, click Add-Ins. In the Add-Ins dialog box, select AutoSave Add-in. Click OK to install the add-in.</li></ol> </li> In the AutoSave dialog box, click to clear the Automatic Save Every check box.</li> Click OK to accept the change.</li></ol> </li></ul>

Additional query words: XL2000

Keywords: kbnofix kbmacro kbprb KB214288

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.