UDF Loop Freezes Unless Calculating in The Sheet it’s in

[VBE313]

I have multiple UDFSs that loop through cells, I have application.volatile on them with worksheet change events that calculate the sheet. But if I am in a different sheet and press calculate, it freezes. Any suggestions?

 

[Yongle]

Perhaps recalculating only the active sheet would work for you
https://www.howtogeek.com/252463/how-to-manually-calculate-only-the-active-worksheet-in-excel/