I have problem with my function.


I have function for selection (cell) from different sheets.
This funcion I use in several sheets.

My problem is with calculation for everything sheets
Because function counts only ones sheet..
Other sheets is showing in cell 0.
(Note after open workbook)

Workbook must recalculation everything sheets after I see value for cell.

Wher si problem?

How to modify the function?
if..
Do not have to recalculate the workbook when you open it?

Thank you for answer.

Function - save in module

Function ID_NAMES(ID)

ID_NAME = "!!!ERROR!!!"
If ActiveSheet.Name = ActiveSheet.Name Then

For ReqRow = 2 To 1000
CellOrder = CStr(ReqRow)
SelectSellFromWorkbook = "B" & CellOrder
If "Block function requirements" = Range(SelectSellFromWorkbook) Then
Exit For
End If
Next ReqRow


For CellOrderCnt = 2 To ReqRow

CellOrder = CStr(CellOrderCnt)
SelectSellFromWorkbook = "B" & CellOrder
If Sheets("ATG").Range(SelectSellFromWorkbook) = ID Then
SignalName = "C" & CellOrder
ID_NAME = Sheets("ATG").Range(NAME)
Exit For

End If

Next CellOrderCnt

End If

End Function