SumByColor isn't working anymore

[itaik]

Hey all,
I added to an Excel file the following module:

Function SumByColor(CellColor As Range, rRange As Range)
Dim cSum As Long
Dim ColIndex As Integer
ColIndex = CellColor.Interior.ColorIndex
For Each cl In rRange
If cl.Interior.ColorIndex = ColIndex Then
cSum = WorksheetFunction.Sum(cl, cSum)
End If
Next cl
SumByColor = cSum
End Function


and it used to work until today and now all I get is ?NAME# value...
I am using Office 365 the latest version 16.0.11231.20164 32Bit and tried using other modules for SumByColor that are posted around the internet but all ends with the same results.

 

[Fluff]

Are you sure that that code is in the same workbook, that you are trying to use it in?

 

[RoryA]

You'll also get that error if macros are disabled.

 

[itaik]

yea, when I start to write the function I get an auto complete prompt for "SumByColor" and it used to work up until yesterday

 

[itaik]

Oh god I feel embarrassed
apparently macros we disabled without any notification and once I set the file on a trusted location it worked!
Thank you very much for helping me get to this conclusion!