View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default saving worksheet automatically

I am using the following function to save changes after any data is entered
into a worksheet:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
ActiveWorkbook.Save
End Sub

Is there a way to use auto save only if data is entered in a certain range?

Thanks for the help,
Mike