Forum Discussion

Copper Contributor

Nov 23, 2021

Solved

Excel freezes when press the close "x" button

I desperately need help. I am developing a large VBA project in Excel (I have some userform, many classes, userdeffined method include in sheet and so on). Unexpectedly, the problem has occurred: whe...

developer

excel

Macros and VBA

OHomenuke
Dec 11, 2021
Problem have been found! It was realy simple. In UDF was commands
Application.Calculation=xlManual ..... Application.Calculation=xlAutomatic

I think, when I close application run recalculate all function and from function when it set xlAutomaic run new recalculate again and again.

OHomenuke

Copper Contributor

Dec 11, 2021

Problem have been found! It was realy simple. In UDF was commands

Application.Calculation=xlManual
.....
Application.Calculation=xlAutomatic

I think, when I close application run recalculate all function and from function when it set xlAutomaic run new recalculate again and again.