Excel 2013 crashes when running macro.

[vimal_]

Hi,

Excel 2013 crashes when running macro. same macro is working fine in excel 2010/2007. there is no addi-in are enabled in excdel. also it does not crash when step-in through lines.

Kindly help!!.. it's making impossible even testing macro.

Vimal

 

[healey21]

Welcome to the Forum,

Have you looked at the Security Settings and also the References in VBA to see if anything is missing. Finally if you post your code then we can take a look for you.

 

[vimal_]

I tried through stepping the code, but it does not show any error and macro completed fine.

 

[healey21]

Have you looked at my suggestions?

 

[vimal_]

Where should i check the security settings?? References are fine.

 

[healey21]

Front end of Excel Under The File Tab and then Options then Trust Centre and then Trust Centre Settings then Macro Settings, it is more than likely you have them disabled.

 

[vimal_]

Yes, it is currently 'Disable all macros with notification'. do i need to change it to enable all??

 

[healey21]

Yes select the last option here (Enable all macros) and hopefully it should work for you.

 

[vimal_]

Still the same problem... does it an issue with 2013??

 

[Michael M]

Maybe you should post the code.