Excel: Auto Save Add-in Macro Does Not Save Preferences

ID: Q92696

The information in this article applies to:

SUMMARY

In version 4.0 of Microsoft Excel for the Macintosh, the Auto Save add-in macro does not save changes you make to preferences when you exit Microsoft Excel.

To save the changes you make to preferences, follow the steps below to modify the Auto Save add-in macro:

  1. From the File menu, choose Open.


  2. In the Open Document dialog box, open the Macro Library folder, and select the Auto Save macro.


  3. Hold down the SHIFT key and choose Open from the File menu.


  4. If the "Revert to Saved" alert appears:

    1. Hold down the SHIFT key and choose the OK button.


    2. From the Window menu, choose Unhide.


    3. In the Unhide dialog box, select Auto Save and choose the OK button.




  5. From the Formula menu, choose Define Name.


  6. In the Define Name dialog box, under Name, type "Auto_Close" (without the quotation marks).


  7. Under Refers To, type "=$B$34" (without the quotation marks).


  8. Choose the OK button.


  9. From the File menu, choose Save.



MORE INFORMATION

For more information about the Auto Save macro, search on Auto Save in Microsoft Excel Help.

Additional query words: 4.00 addin frequency high medium low never autosave auto_save 


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 30, 1999