ActiveSheet.Name not working for some users

[Assamita]

Hi everyone,
I have a report that updates data when the dates are changed either in field C2 (from) or field F2 (to). It goes like this:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim TValue As String, TAddress As String, Tsource As String

If Target.Address = "$C$2" Or Target.Address = "$F$2" Then
    TAddress = Target.Address
    TValue = Target
    Tsource = ActiveSheet.Name
    Call Date_Change(TValue, TAddress, Tsource)
End If

End Sub

This works well in Excel 2010, but it gives an "Object variable or With block variable not set" from 2013 onwards.
The file has a lot of macros as it's a complex reporting file with several capabilities, and the message is displayed when the user clicks on the enable content button.

Debugging, it leads you to the ActiveSheet.Name, and a msgbox ActiveSheet.Name returns the same error message above, so it's like excel it's not identifying the current sheet.

Any ideas of what could I try?

Thank you

 

[Yongle]

Very strange

If the active sheet is the same sheet as the code belongs to then you can use

Tsource = Me.Name

or

Tsource = Target.Parent.Name

 

[Assamita]

Thank you. I think that fixed the issue. I've got a new one, which is weird because I didn't have it before and it's in a complete different part of the code, but I'll deal with that later.

 

[Assamita]

Hi excel gurus. Sorry to resurrect this post, but I identified why this was happening and I wanted to ask you if there's a way to work around. The above error doesn't depend on the Office version. It's happening when the user needs to click the "Enable Editing" button when opening the file from an email:

However, if the user has the following disabled in Excel, the error is not happening:

I guess not, but is there any other way to workaround this issue? something I could put in the code or saving the file in a different way?

Thank you