Autosave Macro

[anniemalec]

Hi There

I've created a spreadsheet to be used as a timesheet using timestamps.

I'm looking to create a macro which will save everytime a timestamp is entered.

The code i currently have is:

Sub Timestamp()
Let ActiveCell.Value = Time
Let ActiveCell.NumberFormat = "hh:mm:ss"
End Sub

But not too sure how to work the save once the timestamp has been entered.

Would this work in the sub? ActiveWorksheet.Save = True?

Any help is appreciated.

Thanks.

 

[Ruddles]

You can't save just one worksheet, you need to save the entire workbook:-

ThisWorkbook.Save