Dear all,

Is it possible to alter a workbook so that when a user opens it he/she is
automatically prompted to save it?

Also I have a cost model in Excel that has a cover worksheet in the
workbook. The cover sheet has a macro button that simply selects the next
worksheet. Is it possible to create prompt window to remind the user to save?


Thanks in advance,

Neil

"Neil Pearce" wrote in message
...
Dear all,

Is it possible to alter a workbook so that when a user opens it he/she is
automatically prompted to save it?

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



Also I have a cost model in Excel that has a cover worksheet in the
workbook. The cover sheet has a macro button that simply selects the next
worksheet. Is it possible to create prompt window to remind the user to
save?


Thanks in advance,

Neil

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

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

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

If it were my office, I'd write a routine to count how many times the user
hits CTRL-S each day. If the number is zero, tell them that when they lose
data, they'll not be paid for the time they spend doing the work over again.

CTRL-S: Greatest idea since beer.


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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".