saving
 

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

Thanks,
Mike

saving
 

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

saving
 

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...
--
HTH...

Jim Thomlinson


"MIke" wrote:

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

Thanks,
Mike

saving
 

Mike,

Thanks. Thats what I needed.

"Mike H" wrote:

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