-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How come I dont have auto-save in the add-ons menu?
- Thread starter chrisdab
- Start date
erik.van.geit
MrExcel MVP
- Joined
- Feb 1, 2003
- Messages
- 17,832
hi, chrisdab,
take a look at menu Tools / Options
tab "Save"
kind regards,
Erik
take a look at menu Tools / Options
tab "Save"
kind regards,
Erik
Upvote
0
erik.van.geit
MrExcel MVP
- Joined
- Feb 1, 2003
- Messages
- 17,832
then an option would be "OnTime"
open workbook without enabling macros
paste the code and close
reopen with macros anabled
in the thisworkbook-module
in a "normal" module
kind regards,
Erik
open workbook without enabling macros
paste the code and close
reopen with macros anabled
in the thisworkbook-module
Code:
Option Explicit
Private Sub Workbook_Open()
sec = 300 '= 5 minutes
Run "do_something"
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Run "stop_it"
End Sub
Code:
Option Explicit
Public sec As Integer
Public when As Variant
Sub do_something()
when = Now + sec / 60 / 60 / 24
Application.OnTime when, "do_something"
'here your save code
'something like the next line
ThisWorkbook.Save
End Sub
Private Sub stop_it()
Application.OnTime EarliestTime:=when, Procedure:="do_something", schedule:=False
End SubErik
Upvote
0
Similar threads
