Time Save msg box

[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

 

[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.)

 

[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.)

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

 

[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).

 

[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 -

Many thanks Dave,

exactly what the doctor ordered.



Steve

 

[Dave Peterson]

If you want to look into a timed save, you may want to review the notes on Chip
Pearson's site for OnTime.

http://www.cpearson.com/excel/ontime.htm