Excel crashes when macros are enabled

**Phillip.C** · 04-02-2013, 04:29 AM

Hi,

I have a workbook with the following macros, all in "module 1". All the macros are activated via an ActiveX form button:

Please Login or Register  to view this content.

When I try to open the file (excel 2013, two different machines), it crashes upon opening. If I open it as a macro-disabled workbook, then there are no problems.
When I first put in the macros (the workbook was already open), there were no stability issues.

Any ideas what could be the problem?

Thanks,

Phillip

**AndyLitch** · 04-02-2013, 04:36 AM

Delete the macros, save and try reopening with macro's enabled... Then you'll know if it's YOUR macro's or something else

Also - have a look in the workbook module, there may be code in there.

**Phillip.C** · 04-02-2013, 04:39 AM

Hi Andy,

I've tried that, it's definitely my macros. The workbook module is empty.

Phillip

**AndyLitch** · 04-02-2013, 04:52 AM

Phil

It looks like you have a lot of sheets.That may be a factor
You could also try remming out your macro's one by one - see if you can pin it down to one specific.

**johndonnelly** · 12-12-2013, 12:09 PM

I think you are experiencing the VBE error. If you check in Event Viewer you will know for sure. But check this out: http://blogs.technet.com/b/the_micro...ing-macro.aspx

The workaround saved me in a few instances.