what's error causes compile error sub function not defined when call macro

[Alaa mg]

Hi
I face problem wasn't show before !!
I try calling macro from sheet change event . it gives error compile error sub function not defined when try call test
how can I fix it,please?

 

[Joe4]

Show us the code of BOTH procedures, please.
Also, what module is this other code located in?

 

[Alaa mg]

hi joe
in standard module

Sub test()

    Dim last_row As Long
    Dim cell As Range
    last_row = ThisWorkbook.Worksheets("data").Cells(Rows.Count, 1).End(xlUp).Row
    Set cell = Range("F2:F" & last_row)
    cell.Formula = "=C2+D2-E2"
    cell.Value = cell.Value

End Sub

in sheet change event

Private Sub Worksheet_Change(ByVal Target As Range)

'   Exit if multiple cells updated at once
    If Target.CountLarge > 1 Then Exit Sub


    If Target.Column = 3 And Target.Row > 1 Then
    If Target.Value = "" Then Target.Value = "0"
    If Not IsNumeric(Target) Then
          MsgBox "please should just enter numbers ", vbCritical
          Application.Undo
          Exit Sub
          End If
        Application.EnableEvents = False
        Call test
        Application.EnableEvents = True
    End If
End Sub

 

[Joe4]

It works just fine for me.
Are both of these procedures in the same workbook?

 

[Alaa mg]

Are both of these procedures in the same workbook?

yes , by the way the error occures when try save the sheet in new file by another macro .

 

[Joe4]

yes , by the way the error occures when try save the sheet in new file by another macro .

OK, that is a very critical detail you want to be sure to mention!
What does that VBA code look like?

Are you sure that the error is with this code that you posted?
Does it give you a debug error option?
If so, and you click the word "Debug", which line of code is highighted?

 

[Alaa mg]

Does it give you a debug error option?

no

ok maybe upload the file to see closely

 

[Joe4]

yes , by the way the error occures when try save the sheet in new file by another macro .

But you say you only get the error when running some "other" macro?
Which file does this "other" macro reside in?
Which module is it in?
What does the VBA code for that module look like?

 

[Alaa mg]

Which file does this "other" macro reside in?

the other macro in standard module
ok I delete some macros and arranged the file again works without problem .
thanks for your time .

 

[Alaa mg]

Hi Joe ,
sorry, I came back but the error causes me headache , do me favor,please could you check my file?

here is the file
FL.xlsm