XL98: AutoSave Command Recorded in Subroutine or Macro (192278)


The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition
This article was previously published under Q192278

SYMPTOMS

In Microsoft Excel, if you record a Microsoft 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("'Auto Save'!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 "ON.TIME 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 problem, 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, disable any ON.TIME macros that are present.

    For example, to disable AutoSave, follow these steps:

    1. On the Tools menu, click AutoSave.
    2. In the AutoSave dialog box, clear the "Automatic Save Every" check box.
    3. Click OK to accept the change.

STATUS

This is by design of Microsoft Excel 98 Macintosh Edition.
Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbbug kbdtacode kbmacro KB192278
©2002 Microsoft Corporation. All rights reserved.