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
|