P
puiuluipui
Hi, i have this macro that save entire workbook at row change.
But this macro is saving entire workbook and it's taking too much everytime
i change row.
Can this macro be made to save only active sheet?
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)
Static lngRow As Long
If Target.Row <> lngRow Then Me.save
lngRow = Target.Row
End Sub
Can this be done?
Thanks!
But this macro is saving entire workbook and it's taking too much everytime
i change row.
Can this macro be made to save only active sheet?
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)
Static lngRow As Long
If Target.Row <> lngRow Then Me.save
lngRow = Target.Row
End Sub
Can this be done?
Thanks!