Saving an Excel Workbook

[Neil Pearce]

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

 

[JoeSpareBedroom]

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

 

[Gord Dibben]

Excel 2002 and later dropped the AutoSave add-in so you can't do that anymore.


Gord Dibben MS Excel MVP

 

[JoeSpareBedroom]

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]

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

 

[JoeSpareBedroom]

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.