After searching online, it seems the issue might not be Excel itself but the activation key. My guess is that Excel detects a non-genuine license and closes when macros are used.