XL: AutoSave Command Recorded in Subroutine or Macro

• Microsoft Excel 98 Macintosh Edition
• Microsoft Excel 97 for Windows
• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SYMPTOMS

In Microsoft Excel, if you record a 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 displays a prompt to save a file while you are recording, one of the following lines of code is recorded in your subroutine.

   Microsoft Excel 98 Macintosh Edition
   ------------------------------------

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

   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)

CAUSE

This 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.

WORKAROUNDS

To work around this problem, do either of the following:

• Once 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.

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.

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.

STATUS

This behavior is by design of Microsoft Excel.