Code stops, VBA editor opens automatically...

[wpryan]

Hi All,

I have some code running on my computer that is operating fine, but on another guy's computer, it gets hung up. on the Worksheet Change, I have this code (partial):

Private Sub Worksheet_Change(ByVal Target As Range)

Application.ScreenUpdating = False
[COLOR=#000000]Application.EnableEvents = False[/COLOR]

If Range("D2") = "Free Flap / small Flap" Then
    With ActiveSheet
        lRow = .Cells(.Rows.Count, "F").End(xlUp).Row
    End With
    Range("F2:F" & lRow).ClearContents
    Application.Range("fFlap").Copy _
    Destination:=Worksheets("Mainpage").Range("F2")
    With ActiveSheet
        lRow = .Cells(.Rows.Count, "F").End(xlUp).Row
    End With
    Range("F2:F" & lRow).Select
        With Selection.Interior
            .Pattern = xlNone
            .TintAndShade = 0
            .PatternTintAndShade = 0
        End With
    Columns("F").AutoFit
    Range("F2").Select
End If

...etc

As stated above, it runs fine on my computer. However, on another computer when cell D2 is changed, the VBA editor opens automatically with the code stopped on the Application.EnableEvents line (highlighted yellow in the editor). He has to hit the run button to get it to complete.

...any ideas?

 

[ranman256]

I think this is a bug in VB Environment. I get VBE stops (where none exist) on lines of code in Microsoft Access too. That person must press F5 to continue.
VB thinks there is a stop point. THERE'S NOT!

I sometimes correct it in Access by compacting the database, but have no idea how this can be done in Excel.