Mova o código para a página ThisWorkbook
ealtereoeventoparaoeventoWorkbook_SheetChange
.
PrivateSubWorkbook_SheetChange(ByValShAsObject,ByValTargetAsRange)SetKeyCells=Range("C9")
Set isect = Application.Intersect(KeyCells, Range(Target.Address))
If Not isect Is Nothing Then
Application.EnableEvents = False
isect.Value = isect.Value - 40
Application.EnableEvents = True
End If
End Sub