F5 to solve freezing
 

Hello,

I sometimes face some freezing problems (due to bugs with the Refedit
control) that can partially be solved by clicking the F5 key and then
selecting a cell to go to. This defreezes Excel. Does anyone know a way to
simulate that programmatically?

Thanks,

Mr. T

F5 to solve freezing
 

Application.Goto Reference:="R5C2" replicates the F5 function. Whether that
will fix your unfreeze problem or not is another question.

Regards
Rowan

"MrT" wrote:

Hello,

I sometimes face some freezing problems (due to bugs with the Refedit
control) that can partially be solved by clicking the F5 key and then
selecting a cell to go to. This defreezes Excel. Does anyone know a way to
simulate that programmatically?

Thanks,

Mr. T

F5 to solve freezing
 

I recently encountered a similar problem. Found it was trying find some non
existant files for some links. Try to break all links and see if it helps. If
the
links are essential check/correct the path(s).

RobertR