VBA code not working on Mac machine running Excel 2011 (works fine on Windows!)

Greetings, all,

Can anyone see a reason why the following code---which executes precisely as expected on a Windows machine---fails to execute on a Mac (the Mac user is running Excel 2011):

Private Sub worksheet_change(ByVal target As Range)
Application.EnableEvents = False
If Not Intersect(target, Me.Range("eraserange")) Is Nothing Then
Me.Range("b10") = Me.Range("b5")
End If
Application.EnableEvents = True
End Sub

A little more detail:
• it's a one-sheet Excel file I created in Excel 2016, Windows 10 machine, .xlsm extension, and emailed to the Mac user;
• the Mac user is familiar with enabling macros on Excel files; indeed, I've emailed him plenty of Excel files before (created on my machine, just as described above), which contain macros that fire upon the mouse-clicking of an object on a sheet---and those work fine for him.
• "eraserange" is just a rectangular, contiguous array of cells on that sheet of which cell B5 is a member.
• the user is instructed to enter something in B5, and whatever is entered SHOULD auto-populate into cell B10.

On various Windows machines it works fine; on the Mac it didn't. And as mentioned, that same Mac guy runs other macros in Excel files I send him without a hitch; the only difference is that they've always been ones which execute with a mouse-click on something, whereas this problem one is a Worksheet Change trigger.

I really appreciate anyone's insight into what the bug-a-boo is here. Been chasing this thing around for two days now. Thanks!

Hey, many thanks, AF! Sounds like a nice conjecture.

I'll be able to run some tests with him over the weekend; he's out of his office for the evening.

Here's where I give away my raw noobee status w.r.t. VBA: How would I go about ♦ verifying that the Change event is triggering? and then ♦ verifying whether the If (Intersect) function was returning T or F?

I suppose re the latter I could insert a line of code to have a message box open up if the IF was returning True?

Sincere thanks for your feedback!

Greatly appreciated, AF; I'll have a good look at those linked resources.

More generally, I need to spend a little time wrapping up a better understanding of this whole "Events" thing. I kinda sorta get the recommendations (received from other sources) for the
"application.enableevents" = false, = true code lines bookends. I'm guessing it doesn't disable the code from actually performing the "Me.Range("b10") = Me.Range("b5")" line,
it just temporarily keeps Excel from treating it as an "event" which would possibly trigger further Worksheet_Change execution.

Interestingly, when I was testing this code on my own machine, I couldn't get the "Debug > Step Into" to operate. I use the Step Into and Run To Cursor features frequently in composing other Subs, so I'm familiar
with their basic operation. But whenever I try to "step into" those seven little lines of Worksheet_Change code, nothing happens.

Just gotta spend a little more quality quiet time with just me, Walkenbach's book, and the VBE Haven't been on the learning curve long enough yet.

Really do appreciate your insights on this one, AF! When the Mac user is back in front of his machine maybe I can fire up a screen-sharing session and see what's going on inside of his box.

Cheers!