Hi,

I have a simple macro running goal seek on every Workbook sheet change. When the macro is done it jumps to the changed cell. This is what I would like to avoid.

My code:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Application.ScreenUpdating = False
Sheet11.Select
    Range("E77").Select
    Range("E77").GoalSeek Goal:=0, ChangingCell:=Range("C11")
Application.ScreenUpdating = True
      
End Sub
So my code jumps to cell C11 after every workbook change. I want to avoid that.

Any thoughts?

regards,
Kbka