--Why dont you use the setting from menu ToolsOptionsSaveSettings'Save
AutoRecover info every'

--A macro would look like the below
Sub AutoSave()
ActiveWorkbook.Save
'OR ThisWorkbook.Save '(as per your requirement)
Application.OnTime Now + TimeSerial(0, 2, 0), "AutoSave"
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"puiuluipui" wrote:

Hi, i need a macro to save a workbook every 2 minutes.
Can this be done?
Thanks!