In a spreadsheet, Col A is used to register processes.
In Col B and Col C are the results of the code in use.
From D2:G30 are the results of other calculations by formulas.
If it was possible:
I would like to protect the results of Col B and Col C and cells D2:G30, being able to continue to insert new processes in Col A and obtain the respective results in Col B and Col C.
I tried via ProtectedSheet but it does not record the results of the calculations.
Code in use:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim w
If Target.Column > 1 Then Exit Sub
Application.EnableEvents = False
w = Target: Application.Undo
If w <> Target Then
Target = w
If Target(, 2) = "" Then
Target(, 2) = Now
else
Target(, 3) = Now
End If
SendKeys "{DOWN}"
End If
Application.EnableEvents = True
End Sub
Thanks in advance.
anvs
In Col B and Col C are the results of the code in use.
From D2:G30 are the results of other calculations by formulas.
If it was possible:
I would like to protect the results of Col B and Col C and cells D2:G30, being able to continue to insert new processes in Col A and obtain the respective results in Col B and Col C.
I tried via ProtectedSheet but it does not record the results of the calculations.
Code in use:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim w
If Target.Column > 1 Then Exit Sub
Application.EnableEvents = False
w = Target: Application.Undo
If w <> Target Then
Target = w
If Target(, 2) = "" Then
Target(, 2) = Now
else
Target(, 3) = Now
End If
SendKeys "{DOWN}"
End If
Application.EnableEvents = True
End Sub
Thanks in advance.
anvs