Article ID: 120871 - Last Review: August 15, 2003 - Revision: 1.1

AutoSave Command Recorded in Subroutine or Macro

Retired KB ArticleRetired KB Content Disclaimer
View products that this article applies to.
This article was previously published under Q120871
Expand all | Collapse all

SYMPTOMS

In Microsoft Excel, if you record a Microsoft Visual Basic for Applications macro or a Microsoft Excel version 4.0 macro while the AutoSave add-in is functioning, and the AutoSave add-in prompts you to save a file while you are recording, one of the following lines of code is recorded in your subroutine. 

   Microsoft Excel 97
   ------------------

   Application.Run Range("AUTOSAVE.XLA!mcs02.OnTime")

   Microsoft Excel for Windows, version 5.0 and
   Microsoft Excel for Windows 95, version 7.0
   --------------------------------------------

   Visual Basic for Applications:
      Application.Run Macro:=Range("AUTOSAVE.XLA!mcs02.OnTime")

   MS Excel 4.0:
      =RUN("AUTOSAVE.XLA!mcs02.OnTime",FALSE)

   Microsoft Excel for the Macintosh, version 5.0
   ----------------------------------------------

   Visual Basic for Applications:

     Application.Run Macro:=Range("'Auto Save'!mcs02.OnTime")

   MS Excel 4.0:
       =RUN("'Auto Save'!mcs02.OnTime",FALSE)
Back to the top

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. This behavior is by design.
Back to the top

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 in Microsoft Excel 97, 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.

    To disable AutoSave in Microsoft Excel version 5.0, follow these steps:

    1. On the Tools menu, click AutoSave.

    2. In the AutoSave dialog box, clear the "Automatic Save" check box.

    3. Click OK to accept the change.
Back to the top
APPLIES TO
  • Microsoft Excel 97 Standard Edition
Back to the top
Keywords: 
kbdtacode kbmacro kbnofix kbprb KB120871
Back to the top
Retired KB ArticleRetired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Back to the top
 

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations