Simpatie.ro - matrimoniale
Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
Nou pe simpatie:
beatrice17
Femeie
25 ani
Bucuresti
cauta Barbat
25 - 80 ani
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides /

[WORD] VBA to Make Toggle Button to Enable / Disable AutoSave

Pagini: 1 Moderat de TRaP, TonyTzu
#1
TRaP
Moderator
Postari: 960
Even if it's useful to have an autosave feature enabled and you want it enabled for most files, but if you want to disable it for some, for example big files,you can do this programatically.

Source: Macro recording


Sub AutoSaveToggle()

If Options.SaveInterval > 0 Then
    Options.SaveInterval = 0 'disabled
    MsgBox ("AutoSave disabled")
Else
    Options.SaveInterval = 10 'enabled, at 10 minutes
    MsgBox ("AutoSave enabled, saving every 10 minutes." & vbCrLf & "To change time interval go to File-Options-Save.")
End If

End Sub


I've tried the following line as they said in some sources I found, but was receiving an error:
Application.AutoRecover.Enabled = True


 
   
Pagini: 1  
Mergi la