auto save code for vb in excell
sweet!!!
thanx
"Gary''s Student" wrote:
Put this in workbook code:
Private Sub Workbook_Open()
Application.AutoRecover.Enabled = True
Application.AutoRecover.Time = 5
End Sub
It will turn AutoSave for anyone opening the workbook. All users will be
safe.
REMEMBER: workbook code, not a standard module
--
Gary''s Student - gsnu200730
"pswanie" wrote:
i work for a company with about 18 branches all over. it i go to tools etc
it will only safe my work on my computer. i email this worksheet to the
other branches and need theyr stuff to auto save as well. i can add a save
code to all my macro's but a powerfail or some happens and they did not run
any macro then all work will be lost
"Gary''s Student" wrote:
Tools Options... Save every 5 minutes
--
Gary''s Student - gsnu200730
|