Microsoft KB Archive/192278

= 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

-

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

© Microsoft Corporation. All rights reserved.