Time Save msg box

K

K1KKKA

Hi all,

Is it possible to have a message box pop up every hour to remind
people to save the workbook, as we use a sheet for a period of 24 hrs
and often it is closed without saving,
i did use the auto save on workbook close event, but this is still not
perfect.


Ideally it would remind the users to save the workbook, and instead of
closing the message it would save upon clicking the Ok button, then
close.


Steve
 
D

Dave Peterson

xl2k and below came with an autosave addin. But that addin wasn't included in
xl2002+.

I don't remember the settings for autosave (I'm not sure if there's a prompt or
if it saves without the prompt.)

But...

If you still have autosave.xla from a previous version of excel, it'll work with
xl2002+. (Not sure about xl2007, though--I haven't tried it.)

Jan Karel Pieterse wrote an addin (works in any version) called AutoSafe (note
spelling).

It doesn't overwrite the existing workbook when it saves. It saves to a user
selectable folder. And when it's done, it either deletes these backups (or puts
them in the recycle bin). And the user can always restore the backups from the
recycle bin.

http://www.jkp-ads.com/Download.htm
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)
 
K

K1KKKA

xl2k and below came with an autosave addin. But that addin wasn't included in
xl2002+.

I don't remember the settings for autosave (I'm not sure if there's a prompt or
if it saves without the prompt.)

But...

If you still have autosave.xla from a previous version of excel, it'll work with
xl2002+. (Not sure about xl2007, though--I haven't tried it.)

Jan Karel Pieterse wrote an addin (works in any version) called AutoSafe (note
spelling).

It doesn't overwrite the existing workbook when it saves. It saves to a user
selectable folder. And when it's done, it either deletes these backups (or puts
them in the recycle bin). And the user can always restore the backups from the
recycle bin.

http://www.jkp-ads.com/Download.htm
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)
Click to expand...

Thanks Dave, had a look, it will assist in what i am looking for,

is there anyway to creat a message box that pops up when a macro
button has been pressed maybe 3 times??


this may also help remind people to save the workbook.

HYCH

Steve
 
D

Dave Peterson

Sure. Add some code to your button that keeps track of a counter.

Option Explicit
Sub testme()
Static ClickCtr As Long

ClickCtr = ClickCtr + 1
If ClickCtr = 3 Then
ClickCtr = 0
MsgBox "don't forget to save"
End If

'rest of code
End Sub

Static means that the value will be remembered between runs (while the workbook
is open).
 
K

K1KKKA

Sure. Add some code to your button that keeps track of a counter.

Option Explicit
Sub testme()
Static ClickCtr As Long

ClickCtr = ClickCtr + 1
If ClickCtr = 3 Then
ClickCtr = 0
MsgBox "don't forget to save"
End If

'rest of code
End Sub

Static means that the value will be remembered between runs (while the workbook
is open).









--

Dave Peterson- Hide quoted text -

- Show quoted text -
Click to expand...

Many thanks Dave,

exactly what the doctor ordered.



Steve
 
Top