If your vba code has any big loops in it, try to add DoEvents command anywhere inside the loop. It will allow you to pause the code without crashing the excel or getting stuck