Thread: Macro disabled with sharing

Hi,
I have a few Macros running in an Excel sheet. They all work when I share the workbook, except one! The Macro that does not work is as under:

Private Sub Worksheet_SelectionChange( _
ByVal Target As Range)

With ThisWorkbook.Names("ActiveRow")
.Name = "ActiveRow"
.RefersToR1C1 = "=" & ActiveCell.Row
End With

Application.EnableEvents = True

End Sub

I have other Macros that work perfectly fine when shared, except this one

Any help would be much appreciated!!