Thread: saving
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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