I am getting the following error when working on a different workbook, whilst this one is open:

tE0n9bM.png

Private WithEvents oCbarEvents As CommandBars
It appears to be something to do with any worksheet containing "Private Sub Worksheet_Change(ByVal Target As Range)" as that's when the error occurs, when switching between sheets in another open workbook.


For example:
Private Sub Worksheet_Change(ByVal Target As Range)
 If Not Intersect(Range("C4"), Target) Is Nothing Then
        If Range("C4").Value = "" Then
            Application.EnableEvents = False
            Range("C4").Value = "'Choose"
            Application.EnableEvents = True
        End If
    End If
End Sub
Does anyone know how this can be resolved?

Thanks.