There are other methods of saving a workbook when it is opened that require no
user intervention or messages.

Why OP would want to save a workbook when no changes have been made is beyond
me.


Gord

On Thu, 8 May 2008 20:50:27 -0400, "JoeSpareBedroom"
wrote:

Well, then his only option is to trap for the user's first keystroke, which
will start a VBA-based timer, throw up a dialog box with an animated Mr
Annoying Paper Clip, and the message "Saving your work - hang on a sec".


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Excel 2002 and later dropped the AutoSave add-in so you can't do that
anymore.


Gord Dibben MS Excel MVP

On Thu, 8 May 2008 14:18:17 -0400, "JoeSpareBedroom"

wrote:

Yes, but why remind them at a moment when nothing has changed? By the time
they make changes worth saving, they may get distracted and forget. How
about using the Autosave feature? I'm using Excel 2000, so my menus may be
different from yours, but click Tools, Add-ins, and look in the list for
"Autosave add-in".