Excel 2007 : 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!!

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here