saving

[MIke]

Is there a way to save a sheet after every entry?

Thanks,
Mike

 

[Mike H]

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

 

[Jim Thomlinson]

You would need to use a macro... I personally would not do it though as your
performance could be awfully slow. If you want help with the macro just post
back. It is quite simple to do...

 

[MIke]

Mike,

Thanks. Thats what I needed.

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