XL98: AutoSave Command Recorded in Subroutine or Macro
Article ID: 192278
Article Last Modified on 9/11/2002
APPLIES TO
- Microsoft Excel 98 for Macintosh
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:
- On the Tools menu, click AutoSave.
- In the AutoSave dialog box, clear the "Automatic Save Every" check box.
- Click OK to accept the change.
STATUS
This is by design of Microsoft Excel 98 Macintosh Edition.
Additional query words: XL98
Keywords: kbbug kbnofix kbmacro kbdtacode KB192278