Hi,
You don't make it clear what you mean by every entry and you can't save a
worksheet, you must save the workbook. So taking your question literally this
saves the workbook every time a cell changes
Alt+F11 to open
vb editor. doubleclick 'this workbook' and paste this in
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
ActiveWorkbook.Save
End Sub
Mike
"MIke" wrote:
Is there a way to save a sheet after every entry?
Thanks,
Mike